Drop down list in a form

[coley]

Combo list

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]

What selected field?

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

 

[coley]

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]

Why not just use combo boxes on the original form?