Form will not open to 'new record'.

D

DMainland

I have one form in a database that is giving me fits. It will not open to a
'new' record for entry of new data. I set the data dentry property to 'yes'
and it doesn't work. I created a macro to go to a new record and placed it
in the 'on click' event on the form and that does not work. The form always
opens to the first record in the underlying table. The form is not directly
tied to the table but gets its data from a query based on the table. Any
suggestions?
 
C

Chris O'C via AccessMonster.com

My guess is that your query is not updateable. You can't add new records to
it, nor can you edit or delete existing records.

Chris
Microsoft MVP
 
R

=Ray=

I have a similar problem, and I suspected something like that might be the
issue, but how do you make the query updateable?

I have a query that simply combines two tables into one, and I have a form
based on that query, which I want to use to add records to both tables
simultaneously. For me, though, it does add records, but the problem is, if I
close the form and reopen it, despite the fact that the query shows records,
the form shows only a single, new (blank) record. Any suggestions?
Thanks,
Ray
 
C

Chris O'C via AccessMonster.com

Change the form's data entry property to No to see all the query's records.

Chris
Microsoft MVP
 
Top