Cannot view queried Data in Form

J

Julius_Council

I have a form for data entry. That data posts in a table, which is queried in
my query_for_form. What I can't seem to figure out, is why the data that is
going to the table, won't show up in my form for review. I would like to be
able to go back and view past records right in the form. Please help this
Access Novice.

Thanks
 
D

Damon Heron

Sounds like you need to do a requery of your review form's record source.
This will refresh the data so it shows.

Damon
 
K

KARL DEWEY

It sounds like you have the Data Entry property of the form set to Yes.
Change it to No and you can review data and add new records by going to the
end plus one.
 
C

Carl Rapson

Julius_Council said:
I have a form for data entry. That data posts in a table, which is queried
in
my query_for_form. What I can't seem to figure out, is why the data that
is
going to the table, won't show up in my form for review. I would like to
be
able to go back and view past records right in the form. Please help this
Access Novice.

Thanks

Make sure the form's AllowEdits property is set to Yes and DataEntry
property is set to No, or you will only be able to add records, not view
existing ones.

Carl Rapson
 
Top