Populate list in COMBO box

[Guest]

I have a form with fields like -

Order No.
.....
OrderPackList, etc.

I want to enlist records from a table into combo box for the order no. that
user will enter in this form and populate OrderPackList.

User should be able to select a record from this list and store in the table
linked with this form.

I am able to display the list in combo box, however, I need to populate it
for the order no. that user enters on this form. At present it lists values
for all Order nos.

How can I achieve this?

Thank you,
-Me

 

[OfficeDev18 via AccessMonster.com]

Populate your combobox with as many hidden fields as necessary. Make sure the
combobox's column count is accurate, and initialize a corresponding number of
columns with length of 0". Then you can take information from Me.ComboBoxName.
Column(X,Y) to put in your table. Please read the Column property blurb,
including the example, in the help file for details.

Hope this helps,

Sam