Data Entry Question

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

Guest

I have created a form that is attached to a query. When you open the form it
has text boxes that are populated with the first record. Their are two text
boxes left blank for updating each record. After entering the new information
into the text boxes I click a command button that enters the information and
then takes me to the next record. After I am done I close the form. The
problem is when I re-open the form those same records come up, but with the
information filled out in the text boxes used for updating the records. If I
put the Data Entry to Yes it clears all the text boxes, if I keep it at No it
brings up all the information, including the updated information. How do I
correct this problem?

Sincerely,
James E.
 
J,
I'm not sure you have a problem...
DataEntry = Yes is used when you do not want users to access previously
entered records. It only allows you to enter NEW records, and once those
records are updated to the table, they no longer are accessible on the form
via PreviousRecord, or GoTo, etc... They're stored in the table, but the
user can'y access them via that "DataEntry = Yes" form.
DataEntry = No allows a user to access all previously entered records for
browsing/deleting/editing (if allowed)... and... also be able to still add a
NEW record... at the end of the database, after the last record.
No, this should just show you a New record. It does not effect any
previously entered data, and all those records should still be in your
table... with all the updated information... just not viewable by your
DateEntry = Yes form.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
I understand that difference between Yes and No on the Data Entry. The
documents that are entered into the database require them to be revised for
additional updates at a later date. Once these documents reach the this date
they automatically are held in this form to be updated. In order to see the
current record I am updating part of the information from the query is
populated in text boxes. Only two text boxes have no information. If I set
the Data Entry Yes and open the form it never brings up the records that need
to be updated. If I set it to know I can enter the data, which is updated
with the a command button (gotonextrecord) and it moves through each record
until the last one is completed. However, if I close the form and then
re-open it the previous records I just updated show in all the text boxes.
What I need is to be able to view the present record at the time of update
without it re-appearing in the form when I re-open it the next time I need to
update records. Hoep this helps.
 
You said:
In order to see the current record I am updating part
of the information from the query is populated in text boxes.
Click to expand...
I cannot understand that statement...
However, if I close the form and then
re-open it the previous records I just updated show in all the text boxes.
Click to expand...
Do you mean that the last 2 values you entered, in the last record you
edited, now show on all your records?
If so...
Are those 2 text fields "bound" to a field in your table. If they are
"unbound", whatever is entered in them will show across all records.
 
I have created a form that is attached to a query. When you open the form it
has text boxes that are populated with the first record. Their are two text
boxes left blank for updating each record. After entering the new information
into the text boxes I click a command button that enters the information and
then takes me to the next record. After I am done I close the form. The
problem is when I re-open the form those same records come up, but with the
information filled out in the text boxes used for updating the records. If I
put the Data Entry to Yes it clears all the text boxes, if I keep it at No it
brings up all the information, including the updated information. How do I
correct this problem?

Sincerely,
James E.
Click to expand...

Try basing the Form on a Query with criteria of

IS NULL

on these two fields. This will ensure that only records which have not
yet been filled in will be displayed.

John W. Vinson[MVP]
 
Back
Top