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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dataresearch - 28 Apr 2008 19:35 GMT

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.

Reply to this Message

Douglas J. Steele - 28 Apr 2008 19:42 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>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
[quoted text clipped - 6 lines]
> of
> debugging ideas - any help woud be very much appreciated.

Reply to this Message

Wayne-I-M - 28 Apr 2008 19:47 GMT

Try the simple answers 1st.

Check the form is not set to Data Entry = Yes

Sounds like it may be ?

Signature

Wayne
Manchester, England.

> 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
[quoted text clipped - 5 lines]
> databases for a while and this has never happened before. I have run out of
> debugging ideas - any help woud be very much appreciated.

Reply to this Message

dataresearch - 01 May 2008 21:01 GMT

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.

> Try the simple answers 1st.
>
[quoted text clipped - 11 lines]
> > databases for a while and this has never happened before. I have run out of
> > debugging ideas - any help woud be very much appreciated.

Reply to this Message