Query passing to subform

[drunkenneo]

I have searched all over but not got any idea, Situation is i have a subform which is controlled by a query eg . Fname&" "& Lname as Name, order_number. and i have form which have combobox.



When form opens the query works fine but when i search value order_number in combo box it gives the result but with ?Name in Name column.

I know i can do this with Filter method, and rewriting the query, but i want to use it by passing the value in query of subform. Please Help.

[ItsMe]

You can adjust the Row Source of your combobox. You can copy the SQL from the Combobox's property window and paste it into the form's load event so you can see it better. You can also use the Zoom feature in the proporty window for the Row Source.

You can do something like

Dim strSQL As String
strSQL = "SELECT * FROM tblMain"
Me.cmbCombo.RowSource = strSQL

In the form's load event