Veiwing records on a form

  • Thread starter Thread starter Spider
  • Start date Start date
S

Spider

I entered data into a form, clicked on the arrow to move to the next record,
the data was saved - no problem. The data is correctly stored in each
related table, and is visible in the associated query. The problem is the
data is no longer displayed in the form once the focus is moved to the next
record, or the form is closed. Nothing there; the form is just as if nothing
had been entered at all. Any ideas?
 
Sounds like the form's Data Entry property has been set to Yes. This is a
special mode just for entering new records, so it excludes existing data.

There could be other reasons, e.g. if the form has a filter, or is based on
a query with criteria that exclude the records, or it is a subform and the
foreign key field is null.
 
You're right, the Data Entry was set to yes, and I believe the null fields
are a problem as well. I am using a tabbed form based on a query of all
tables. When I leave items blank on the second tab, I have problems (empty
primary keys). So I'm thinking I may try subforms instead. If I understand
how they work correctly I can tie the subforms directly to a table and avoid
some of the problems I'm experiencing. Thank you for your help with this. I
will try again. (Also checked out your website. I will be going there
again). :-)
 
Back
Top