Passing parameter to rowsource of combo box dynamically

Hi
I have a main form which contains questions and a subform within it which contains elements which relate to the main form. they are linked by a field called question_ref so if I page through the records on the main form the elements that are relevant to that question display in the subform.

Within the subform I have a combo box which calls a table which contains the following question_ref and a text field. I would like to be able to make the combo box only display data in the combo box that relates to the current question in the subform.

I have tried setting the rowsource of the combo box as following but is does not display any values.(error enter parameter me.question_ref)
Any ideas why it is not picking up the data from the me.question_ref field and passing across to the rowsource.

Any help greatly appreciated

re: Passing parameter to rowsource of combo box dynamically

Me. is an object reference that works within VBA. It is entirely unknown to (unrecognised by) the SQL interpreter.

It should recognise a fully qualified reference though. The form must be open of course (You may find Referring to Items on a Sub-Form useful).

re: Passing parameter to rowsource of combo box dynamically

Hi Thanks for that
I can now get the combo box to display the options for question1 correctly but when I go to the next record in the subform it shows me options in the combo box for the previous record so its not refreshing the combo box as it goes through the records in the sub form, it there someother code I need to do this

re: Passing parameter to rowsource of combo box dynamically

The SQL doesn't keep repeating its execution.

If the criteria change somehow, and you want to reprocess the query, you need to call a .Requery on the object (You only refer to it as a ComboBox on your SubForm) that the SQL is in.

Does that make sense?

re: Passing parameter to rowsource of combo box dynamically

Great thanks for your help thats owkred

re: Passing parameter to rowsource of combo box dynamically

Great :)

I'm always pleased when something owkrs (LOL).

J/K We all live on typos here ;)