If you don't want Form 1 to have to be open when you want to see data in
Form 2, then you'll need to have Form 2 get the desired data via a query
from the tables' data.
It sounds as if Form2 is a continuous forms view for the form. In that case,
an unbound textbox, which is what you're using (even though you've set the
Control Source to be equal to the combo box's info), will show the same
value in all records, and won't be changed for each record. Only way to do
that is to bind the textbox to a field in Form 2's record source. This
further supports changing Form 2 to what I've said above -- don't base Form
2 on values in Form 1, but rather have it get its data from its own query.
If you need Form 2 to "reflect" in some way what is in Form 1 (not sure why,
as you said that you don't always want Form 1 open when trying to view data
in Form 2), then Form 2 will need the ability to filter its data based on
some choice in Form 1, or some other method of limiting what Form 2 shows. I
can't give more specific recommendation re: this right now, as I don't fully
understand the entire Form 1 and Form 2 setup and linking.
--
Ken Snell
<MS ACCESS MVP>
Larry said:
Ok now that ive been messing with it now ive run into another problem. I
have a Record ID in my tables and i have a S/N and a status column i need
this text box to show the status of each S/N in form2 so when i view form2
it will show me the current status of that S/N. At the momment when i open
form1 it will say complete in status combo. Then when i open form2 it will
say complete in every status box and they all are not complete. Also form1
has to be open for the form2 box to work right or it says (#name?) Is there
a way for this text box to use the table column data by ID or S/N so it will
show the correct status each time i change the record in the form.
