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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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


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


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

Daniel
 
Daniel said:
You were right, but how can I make it updatable?! What makes a query
updatable or not?
Click to expand...

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.
 
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
 
Back
Top