Combo Boxes

[hainejo]

I am trying to build a form that uses combo boxes to select records. The form has two dropdowns used to select the record. The first on lets the user select the order number and the second one lets the user select the order version number. Each order can have multiple versions or only one version. The combo box that lets the user select the order number works, but I cannot get the combo box for version numbers to populate correctly. How can I populate the version numbers combo box with the available versions based on the the order number selected in the first combo box?

 

[Philem]

Hullo. What needs to be done is:
1)Make a query that will give you the version number, with a criteria of the order number. Be sure you are getting the correct information. Once tested, change the criteria to [Form]![frmName]![cboField] where frmName and cboField are appropriate to your situation
2)In the OnChange event for the first combo box, insert a procedure that will run said query.

That should give you what you need.

HTH

P[/list][/list]

 

[hainejo]

Thanks. How would you write a procedure to run the query?

 

[Philem]

Open the Design view of the form. Get to the Properties of the first(trigger) combo-box. On the Event tab, in the OnChange field, select [Event Procedure] and click on the elipisis (...) In the code window that pops up, type

DoCmd.OpenQuery qryName, , acReadOnly

Remember to change qryName to match your situation. Again, this is off the cuff and UNTESTED, but, should help you along the way.

P

 

[hainejo]

How do I tie the value from the query into the second combo box?

 

[Philem]

In the ControlSource of the second box, select the query in question.

P