Access open form

Hi,

I have a search form which applies filters to a database and returns the fields that match my criteria, a summary of the information is then loaded into textboxes and im trying to click on one of the boxes to open a new form and load the relevant record into that form. The problem is, I can open the form but it isn't loading the relevant record into the form.

My code is

Code: Select all

Private Sub record_id_Click()
DoCmd.OpenForm "record_details", , , _
        "[record_ID]" = """ & Me.record_id & """
End Sub

where record_details is the form im opening, record_id is the textbox and record_ID is the field in the database that im using to find that record.

Can any please tell me whats wrong - at present im getting no data in the form but it is bound properly.

Thanks