No way to add record

M

Mike Busch

I created a form and try to add a record. The button I create tells my that
"Can't go to specific record". The insert record drop-down, icon or command
on the form are not available. I can add a record in the Table. Any ideas.
Thank in advance.
 
J

Jeff Boyce

Mike

Forms can be bound to queries or tables, or to nothing. Is your form bound?
Directly to the table? If to a query, is the query itself updatable?

Forms can have their Data Entry property set to Yes or No -- how is your's
set?
 
M

Mike Busch

It is bound to a query. I would assume that the query is updateable. I have
had the Data Entry set both ways. I am able to insert new records from the
table. Hope this helps.
 
R

Rick Brandt

Mike Busch said:
It is bound to a query. I would assume that the query is updateable. I have
had the Data Entry set both ways. I am able to insert new records from the
table. Hope this helps.

If you actually try it I'm guessing that your query is NOT updateable.

There is a help topic named "When can I update data in a query?" that you need
to read.
 
Top