Losing data

[bohon79 via AccessMonster.com]

Need some help. I have two forms that are virtually the same with one form
that has a little more data then the other. The question that I have is that
on one form it will allow me to add new personnel when they come into the
unit. Then I click a button to add them to the database and into another
form that will allow me to update there information as time goes by. The
problem that I am running into that one of the fields on the first form has a
drop down where I either put in a yes or no. Same thing on the other form.
When I click on the button to send them to the database, I go into the form
that I will be able to update there information and the data that was suppose
to be in the field on this second form is gone.

 

[John W. Vinson]

Need some help. I have two forms that are virtually the same with one form
that has a little more data then the other.

The FORMS don't contain any data. They're just windows. The data exists in
tables, and only in the tables!

What are the forms' recordsources? Are they queries on the same table?

The question that I have is that
on one form it will allow me to add new personnel when they come into the
unit. Then I click a button to add them to the database and into another
form that will allow me to update there information as time goes by. The
problem that I am running into that one of the fields on the first form has a
drop down where I either put in a yes or no. Same thing on the other form.
When I click on the button to send them to the database, I go into the form
that I will be able to update there information and the data that was suppose
to be in the field on this second form is gone.

What's the code on the button? Possibly the record is still not written to the
table.


John W. Vinson [MVP]