Combo Boxes

[thesuggs]

I have a problem in my forms concerning a couple fof combo boxes. I have two fields which are Pre & Post Assessment.

I am wanting the Post Assessment Combo Box to be based on the answer recieved in the Pre box. I think i have the code for this however how do i save the data.

Because the data in the post assessment could be coming from 3 fields i am confused as to how to get past this

Any help would be much appreciated.

 

[Bilbo_Baggins_Esq]

The only time I use combo boxes, I link the FORM to an actual table (instead of a query).
Then I link the SOURCE for combo box to a query that has the desired choices in the desired table field.
Then I use a VBA OnChange event (you could also use a macro for this) to close and open the form (saves the record in the table with the drop down chosen).
Then your second combo box can be sourced from a different query based off the value provided in the first combo box.

 

[thesuggs]

I am confused as to what to do. The form i have is already linked to a table, i just want the results from the second combo box linked to ths query. do i put the code in the rowsource in the table properties for the second combo box

thanks

 

[Bilbo_Baggins_Esq]

i just want the results from the second combo box linked to ths query.

If you have the form linked to a table then what query?

The rowsource for the second drop box needs to be seperate query that is dependant on the criteria selected in the first drop box.

 

[boblarson]

The only time I use combo boxes, I link the FORM to an actual table (instead of a query).

Actually not optimal. Setting the form's record source to a query instead of the table gives you options such as sorting.

I THINK what thesuggs is asking, is how to use the combo box to limit a separate query. And the answer is to reference the combo box in the criteria of the applicable field, in the query. The syntax in the criteria of the query (in the QBE grid) is:

[Forms]![YourFormNameHere]![YourComboBoxNameHere]