Form Help

[ChrisDo11]

I have a form. I input a file number into the first field. Then i tab to a second field(combo box) which has queried names based on the file number entered. Each name has another number associated with it. When i select the name from this drop down i want the number associated with this name to be entered into another field below.

Is this possible?

 

[Elana]

Yes, place an unbound text box on your form. In the control source of the text box, place this code:

=[cboYourComboBoxName]

This will display whatever value is located in column(0) of the combobox. If you want to display a value that is located in another column in the combobox, enter this:

=[cboYourComboBoxName].[column](1) or whatever column number you want to display.

 

[ChrisDo11]

Error

Thanks,

But when i type that in i get the following in my field and it doesn't update.

Name#?

??

 

[Elana]

what is the name of your combo box?

 

[ChrisDo11]

Combo2

 

[sambo]

Did you translate the post literally??

=[cboYourComboBoxName]


If so, then you need to replace cboYourComboBoxName with the actual Name of your combo box.

 

[ChrisDo11]

This is what i put in;

=[cboCombo2].[column](1)

 

[Elana]

Then take out the "cbo" if those letters aren't actually in the name of the combobox.

=[combo2].[column](1)

"cbo" is a prefix I use when I name combo boxes. Helps identify the type of object when I'm doing code.

HTH

Elana

 

[ChrisDo11]

works great...

thanks alot!!!