Combo Box needed to fill in multiple form fields.

Y

Yeahyeahyeah

Hi,

I have a form that updates information regarding work-related incidents. The
primary data (date, place, people involved, etc.) is already stored in
tblIncidents and the new data will be stored in a table called
tblIncidentUpdates. The tables will be linked by a field called
IncidentNumber.

Since I have approx. 50 open incidents at any given time I want to put a
drop down combo box at the top of frmIncidentUpdate so I can scroll down a
list of all open incidents (open or closed criteria is contained in a field
in tblIncidents) click on that incident, and have the pertinent data from
tblIncidents filled into the appropriate text boxes I've set up in
frmIncidentUpdate. This should allow me to fill in new data which will be
stored in tblIncidentUpdate.

So how do I set up the combo box?

Thanks,
David
 
Top