View Full Version : Drop down list in a form


coley
03-01-2005, 04:30 AM
Hi

I have created a form to look like an Input Box as drop downs can not be used with them. How do I populate the selected field to the original form?

So instead of using an input box I am using a form to collect this one piece of data.

Cheers

modest
03-01-2005, 07:46 AM
What selected field?

Like: Me.[Input Box Name].Value = FORMS![Original Form Name]![Field On Form].Value?

coley
03-03-2005, 04:49 AM
Hi

The situation is this

Click on a button to run a series of input boxes, all done by code, I need to add into the code to open a form with the drop list, then populate the a field on the original form.

Original Form name = Project Log Sheet
Field that needs to be populated on original form = TxtITArea
New form that contains combo box = IT Area
Combo box on new form = ITAreaList

So instead of the code TxtITArea = InputBox("Please Enter IT Area") I need to do the above.

Any ideas?

thanks

Rich
03-03-2005, 04:52 AM
Why not just use combo boxes on the original form?