Combo Box Issue

[WarrenB]

In a form I have a combo box. However, I want the values that appear in the combo box to be the result of a query. However in order for the query to work I need a value entered in a text box in the form to be passed to the query to give an output from the query to go into the text box. How do I go about this?

Thanks
=================
Warren Brown
wazzer@btinternet.com
=================

 

[BoxHead]

Warren,

View your Combo Box query in QBE grid view. Set your criteria for the criteria to the name of the form's text box.

   [Forms]![Name_of_your_Form]![Combo_Box_Name]

On the BeforeUpdate event of the textbox, run

   ComboBoxName.Requery

HTH


John

Use what you have,
Learn what you can,
Create what you need.