Access Form Question

  • Thread starter Thread starter Erik
  • Start date Start date
E

Erik

Ok, I am sure this is a simple problem. But noone here
seems to know the answer. I have a form connected to a
single table. I have entered information into this form
and it shows up correctly in the table. However, after I
close the form, and access and start it up again later,
the information already in the table does not show up in
the form. I can not scroll through the different entries
that I had previously made.

Is there some toggle or something that I forgot to
activate?

Thanks.

Erik
 
Hi Erik,
Is the table name showing in the record source
property of the form? Go into design view by clicking on
VIEW..DESIGN VIEW or clicking on the blue triangle on the
tool bar at the top of your screen. Once you are in design
view, click on VIEW...PROPERTIES. Check the record source
for the form.

The Easy Day
 
Erik said:
Ok, I am sure this is a simple problem. But noone here
seems to know the answer. I have a form connected to a
single table. I have entered information into this form
and it shows up correctly in the table. However, after I
close the form, and access and start it up again later,
the information already in the table does not show up in
the form. I can not scroll through the different entries
that I had previously made.

Is there some toggle or something that I forgot to
activate?

Thanks.

Erik
Click to expand...

Is the form's Data Entry property set to Yes, by any chance?
 
It sounds like you may have set the form's Data Entry
property to Yes, which allows you to enter new records
only.

HTH
Kevin Sprinkel
 
I knew it had to be something really simply. That did
it. Thanks to you folks that responded.

Erik
 
It is very likely you have the form "data entry" property set to yes.

Often, people want the form to automatically open up to a new blank record.
This means you can see what you entered...but previous stuff you can't see.

So, set the forms "data entry" property to "no". You will find this setting
in the forms property sheet (data tab).
 
Back
Top