Combo Box on Form Question

[Wet_Blanket]

So I have a form, where values are populated via a DLookup function when you enter an account number. The problem is that I want to add a combo box, where a value in one table (where I will be getting the info) has to match the value of a form field that is populated by the DLookup function.

Is this possible (pretty much link a value on a form to a value in a table for the combo box's query)?

 

[ShaneMan]

So I have a form, where values are populated via a DLookup function when you enter an account number. The problem is that I want to add a combo box, where a value in one table (where I will be getting the info) has to match the value of a form field that is populated by the DLookup function.

Is this possible (pretty much link a value on a form to a value in a table for the combo box's query)?

Hey Wet_Blanket,

I hope I am following what your asking. You should be able to go into the combo boxes Row Source, in design view, and set the criteria of the column you want to match the text control on your form. In the criteria section you should be able to type something like this: =Forms![FormName]![TextBoxName]

HTH,
Shane

 

[Wet_Blanket]

Hey Wet_Blanket,

I hope I am following what your asking. You should be able to go into the combo boxes Row Source, in design view, and set the criteria of the column you want to match the text control on your form. In the criteria section you should be able to type something like this: =Forms![FormName]![TextBoxName]

HTH,
Shane

Thanks for the quick reponse. I've ended up using a list box that has a query as the row source to populate it. Now the problem I have is that when I go to create the next record, the data from the previous record still populate the box. How do I get the query in rowsource to re-run on each new entry?

 

[ShaneMan]

Thanks for the quick reponse. I've ended up using a list box that has a query as the row source to populate it. Now the problem I have is that when I go to create the next record, the data from the previous record still populate the box. How do I get the query in rowsource to re-run on each new entry?

Have you tried requering the listbox? Me.ListBoxName.Requery

HTH,
Shane

 

[Wet_Blanket]

Have you tried requering the listbox? Me.ListBoxName.Requery

HTH,
Shane

Thanks, that worked. Simple solution.