Form not updating data from query

avalon60

Registered User.
Local time
Today, 10:14
Joined
Jun 3, 2012
Messages
53
I have 2 forms set as pop ups so I can reduce their size, on a tabbed form.

One of the forms does not save or update any information I enter.
I have entered 2 records into the said form, clicked on save, then closed the form down, and when I open it up again, the data is not there or showing, yet it is showing in the query.

I have checked that the form is bound to a query, and also checked the text boxes, and there are no apparent errors.

The other form does update or save the data, and there are 12 records showing.

Any ideas please?
 
What is the form's Data Entry property? And what is the code to open it?
 
The form's data entry property is Yes, and I'm not sure what you mean by what code is used to open it.

I created the 2 forms from 2 queries, then put them both on a tabbed control.
The form on Page 1 works ok and shows the data, but it is the form on Page 2 which does not save the data, although it is showing in the query.

Edit:
I have found that the Data Entry should be set to No, and on doing that the form now shows the records.

Doh!

Thanks
 
The Data Entry property is your problem. "Yes" is telling it you just want to enter new records, not display existing ones.
 

Users who are viewing this thread

Back
Top Bottom