Loading a recordset from a combo box

[shrive22]

I have a form that when opened is blank I have a combo box that a user can select a customer number from. THen after they select the cust_No I want to be able to update the recordset for the form based on an sql statement that has the value of the combo box that the user selected in it. Does anyone know how this can be acheived in code?

Thanks

 

[bat17]

Normaly you would do this by having the form based on a query and use the combobox for the criteria of the query.
There is an example of this in the Northwinds Database that comes with Access.

HTH

Peter

 

[shrive22]

do you know which form in the sample db uses this method?

 

[bat17]

The example that I was thinking of actualy came with the Solutions Database and is the Edit Products form.
The Solutions database came with A97 but I am not sure about latter versions.

HTH

Peter

 

[shrive22]

Can you describe how you make the combo box the criteria for the query? I know how to make a forms recordset based on a query.

Thanks

 

[bat17]

you refer to the combo box in the query reiteria grid
[Forms]![MyForms]![MyCombo]

and in the ufterupdate of the combo you run a requery to refresh the data to match the combobox

The combobox is an unbound field

HTh

Peter

 

[shrive22]

When I put the forms!docsdue!cust_name in the criteria then view the query it asks me for the parameter value??


For the requery Im not exactly sure how you do that?



Thanks

 

[shrive22]

I got it working thanks