Entered data stored in Access table but won't show up in reopened

  • Thread starter Thread starter dataresearch
  • Start date Start date
D

dataresearch

I have created a multiple table Access 2003 database linked by a common key
field. Each table has its own form and the record source for each from is
correct. The tables are all linked properly in Relationships. If I enter
data into the forms, it is stored correctly in all the tables. It remains
visible in each form until I close the form, but when I reopen the form I
cannot scroll through the records that have been entered. The forms look
blank, but the data is in the tables! I have been making these types of
databases for a while and this has never happened before. I have run out of
debugging ideas - any help woud be very much appreciated.
 
Have you perhaps set the DataEntry property of the form to True? If so, set
it to False.

The Data Entry property doesn't determine whether records can be added; it
only determines whether existing records are displayed.
 
Try the simple answers 1st.

Check the form is not set to Data Entry = Yes

Sounds like it may be ?
 
Thanks Douglas and Wayne! That worked! It is pretty counterintuitive, though,
to set data entry to 'no' when you want to enter data!! : )

God bless.
 
Back
Top