S
Sean
I am having trouble using a combo box for selecting a field in my table and
then having the rest of the fields on the form populate based on the combo
box selection and would like some assistance. I have reviewed may posts here
but I am not getting it. Here is what I have:
I have a table with 22 fields in it and my form is based off that table. 18
of the fields in the table are updated from another database through an an
append query and that data will not change. However, the other 4 fields will
change based on the user inputting data on the form.
I want the form to have 2 combo boxes. The first will select the WorkCenter
from the table WO_Tracking, the second will select ItemBillNumber from the
same table where the WorkCenter = combobox 0. Then the remaining 20 fields
on the table will populate the rest of the form based on the selection in the
1st 2 combo boxes.
Then the user can review 18 of the fields that are read only and then make
changes to 4 of the fields, then go back to WorkCenter and start again with a
different record set.
If anyone can offer some assistance on how to do this and what type of code
to put where I would greatly appreciate the assistance.
Thank You,
Sean
then having the rest of the fields on the form populate based on the combo
box selection and would like some assistance. I have reviewed may posts here
but I am not getting it. Here is what I have:
I have a table with 22 fields in it and my form is based off that table. 18
of the fields in the table are updated from another database through an an
append query and that data will not change. However, the other 4 fields will
change based on the user inputting data on the form.
I want the form to have 2 combo boxes. The first will select the WorkCenter
from the table WO_Tracking, the second will select ItemBillNumber from the
same table where the WorkCenter = combobox 0. Then the remaining 20 fields
on the table will populate the rest of the form based on the selection in the
1st 2 combo boxes.
Then the user can review 18 of the fields that are read only and then make
changes to 4 of the fields, then go back to WorkCenter and start again with a
different record set.
If anyone can offer some assistance on how to do this and what type of code
to put where I would greatly appreciate the assistance.
Thank You,
Sean