form not showing records in related tables--only inputs data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Form created with wizard in Access '02 comes up with a blank as record 1. It
will insert records into related tables but will not show records once closed
& reopened. There must be some real basic thing I done wrong--any help would
be appreciated
thx, lad
 
The DataEntry Property of the form is probably set to yes.
Open the form in design view, open the properties (Alt+Enter), press on the
left top corner of the form to get the properties of the form, look for
DataEntry Property,
if it set to true, change it to false
 
Thanks for reply.
The data entry property is set to no--I switched to yes, closed form, &
switched back--same thing.
 
It should be set to no.
How do you open the form, are you using a command line?

If you have the "acFormAdd" in the command line then remove it

docmd.OpenForm "FormName",,,,acFormAdd


Docmd.open
 
Form is opened by clicking in the database window, not from code or
macro--makes no difference as far as I can tell
 
If the DataEntry Property of the form is set to No, and you open the form
from the database window, it should display all the records.
Unless you have some kind of a filter in the form properties, or in the
record source of the form that return no records, and you left with only data
entry.
 
It looks like one of the tables had no entries for the records the form was
accessing, which is why the records were not comming up--my error
Thanks much for the responses, lad
 
Back
Top