Hi I am trying to create a form which consists of a combobox displaying client ref No accompanied with a button when clicked will return a form displaying all records associated with the client ref No.
I have already created a seperate form which displays all the records of the clients
When i click the button, it opens the form but the form does not display any records,
Do you have the form bound to a query that is based on your combo box? One way would be to create a query that references the first form's combo and use that as the recordset for the second form that displays all the records.
Does that make sense? If not reply and I'll try to explain a little clearer.
Don't worry about the combo box...you need to put something in the recordsource for the second form (form that displays the results). Something like: SELECT * FROM myTable WHERE RefNo = " & Forms!Form1!cboRefNo
Make sure that the first form stays open otherwise this approach will not work. Give that a try and let me know.
When you go to properties for your form, make sure the "ALL" or "DATA" tab is selected. The Record Source property MUST be there. All versions of Access have it.
When the property sheet is open, it should say "Form" at the top. If it does not, click in the dark grey area outside the boundaries of your form's width/depth to select it. You can also click the little box to the left of the top ruler.
Hi I am making some progress now, i have located the recordset and entered the following query SELECT * FROM Marac2 WHERE Guardian_Reference = " & "'" & Form1![Combo0] '" - but i am getting syntax error, missing operator