Not able to view records through form?

  • Thread starter Thread starter Bayou BoB
  • Start date Start date
B

Bayou BoB

I have several forms for employees to be able to enter data into the
database. I have the forms all set to Data Entry "Yes" in the form's
property so that when the form is opened, it opens to a blank entry
rather than having to click on the navigation buttons to get to a new
form.

When they input data, it does in fact go into the tables
appropriately...and I can view all of the data this way. The record
and navigation buttons at the bottom of the form are present...and yet
every time you close the form, and reopen it, it's always set to "1"
and you cannot view any of the previously entered data. What is the
problem with the forms? You used to be able to cycle through the
records before I changed the Data Entry setting to "Yes". If an
employee creates 3 new records, you can actually cycle through them
while the form is still open...but once it's closed, they're in the
table and not viewable again through the form. The form itself is
built on a query, and it too is accurately showing the entered data as
being present. How do I fix this? Many thanks.

Kevin
 
Hi,
That's what setting the form's Data Entry does. You can only
view the records you're entering.
Set it to 'No' and you'll be able to see previously entered records.
 
Kevin

I really don't think you've thought this through, or you're not explaining
yourself very well! You have set Data Entry to Yes... in other words when
you open the form it will ALWAYS be blank! If you enter 10 records, you can
view any of them before closing the form. When you open the form again it
WILL be blank! Because you have set Data Entry to Yes! You have answered
your own question if only you had read it after you wrote it! The solution
is to programatically set Data Entry to No when the form is open... Place a
button on your form and in its OnClick event put Me.DataEntry = 0 into it.

HTH.

Tom.
 
Back
Top