Combo Box to populate form

  • Thread starter Thread starter AccidentalDBA
  • Start date Start date
A

AccidentalDBA

I'm new, I've searched the archives, and I think I'm missing something fairly
obvious but I can't find a solution. I have a form that I use to enter data
into a table. It has some combo boxes that pull data from other tables and
it generates a unique key field based on several criteria. I want to make
another form to update/edit the data. I need to use two because once the
data is created some fields cannot change (like, the creation date and who
created it). In the edit form, I want to have a combo box that allows the
user to select the key field (in this case, the Test_Request_Number) and when
selected have it populate the other fields on the form. Assume that all the
other fields on the form are Text Boxes, and that all the data resides in the
same table. There are no sub-forms or other tables involved at this point.
I can make the combo box to select the Test_Request_Number, but I cannot get
any of the other fields to update. What am I missing?

Thanks.
 
AccidentalDBA said:
I'm new, I've searched the archives, and I think I'm missing something
fairly
obvious but I can't find a solution. I have a form that I use to enter
data
into a table. It has some combo boxes that pull data from other tables
and
it generates a unique key field based on several criteria. I want to make
another form to update/edit the data. I need to use two because once the
data is created some fields cannot change (like, the creation date and who
created it). In the edit form, I want to have a combo box that allows the
user to select the key field (in this case, the Test_Request_Number) and
when
selected have it populate the other fields on the form. Assume that all
the
other fields on the form are Text Boxes, and that all the data resides in
the
same table. There are no sub-forms or other tables involved at this
point.
I can make the combo box to select the Test_Request_Number, but I cannot
get
any of the other fields to update. What am I missing?
Click to expand...

What you describe is one of the features of the Combo Box Wizard. Make sure
the "Magic Wand" in the Toolbox appears to be pressed, drop a Combo Box on
the Form, and follow the Wizard's prompts.

Larry Linson
Microsoft Access MVP
 
Does your form "know" it is supposed to get the record who's
[Test_Request_Number] was just selected? Is your form based on the table
directly? (in which case, you'll need to filter for that [Test_...].

Is your form based on a query? (if so, you can include the combo box's
selected [Test_...] as a criterion)

In either case, you'll want to use the combo box's AfterUpdate event to tell
the form what to do next.

Regards

Jeff Boyce
<Office/Access MVP>
 
Back
Top