No longer have a blank entry line?! What happened?!

Hello,

I had a form that had as a record source a table. When the form was opened it showed a listing of the data but always end with a blank entry line so that the user could add a new entry.

I have recently had to modify the record source to be now based on a query that uses three tables. However, the form no longer displays a blank entry line anymore. How can I get it back? Why is it gone in the first place?

thank you for the help,

Daniel

Sounds like your form is now based on a query that is not updatable. Open
the underlying query and see if you can add records there. I'm betting
because of the types of joins/selections that you will not be able to.

Rick B


"Daniel" wrote in message
...
Hello,

I had a form that had as a record source a table. When the form was opened
it showed a listing of the data but always end with a blank entry line so
that the user could add a new entry.

I have recently had to modify the record source to be now based on a query
that uses three tables. However, the form no longer displays a blank entry
line anymore. How can I get it back? Why is it gone in the first place?

thank you for the help,

Daniel

You were right, but how can I make it updatable?! What makes a query updatable or not?

Daniel

That is a harder question. Copy and paste your query in here and we can
look at it. Hopefully an MVP or someone a little better at that type of
thing will see it.

Rick B


"Daniel" wrote in message
...
You were right, but how can I make it updatable?! What makes a query
updatable or not?

Daniel

"Daniel" wrote in message

You were right, but how can I make it updatable?! What makes a query
updatable or not?

See the help file topic, "When can I update data from a query?" In the
Access 2002 help, this topic is located under "Queries" - "Opening,
Viewing, and Running Queries".

If that doesn't help you figure it out, post the SQL of the query.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

I had the same thing happen to me the other day. My data came from one table
only, so there was no updatable problem. What I found was, that I had for
some reason some time ago, for some reason, I removed the primary key from
the main table. As soon as I put the primary key back to my main field, the
input line reappeared again.
Annelie

"Daniel" wrote in message
...
You were right, but how can I make it updatable?! What makes a query
updatable or not?

Daniel