Query from a child record in a one to many form

[TimW]

When I execute the following query in a subroutine called by a double click on a child record in a parent-child (one to many form) I get a Runtime error 3601. Too few parameters. Expected 1.

        strSQLString = "SELECT Enquiry.Customer_Name, Enquiry.Rooms " & _
                       "FROM Enquiry " & _
                       "WHERE [Enquiry.Enquiry_Number] = " & Me.Enquiry_Number
        Set rs = CurrentDb.OpenRecordset(strSQLString)

Enquiry is the Parent table and "Enquiry_Number " is the joining field (master key in the Parent table "Enquiry")

So in fact I am trying to retrieve values from two fields in the parent table that are visible on the form (Customer_Name and Rooms) and I think this where the problem lies?

[ranman256]

are you sure 'Enquiry_Number' is the name of the text box? (not the field, tho they can be the same)
did you put a stop on that line (F9) to see if it has a value?
dd you see if the SQL string was legal? (again F9)

[TimW]

When I try F9 and Shift F9 I can see the query comes up with a Boolean value of false. It seems it is not picking the record up.

I have some similar code immediately after this code that works fine, but it is querying a connected table that is not the parent of the form, see

        strSQLString = "SELECT Hotels.Email, Hotels.Contact " & _
                       "FROM Hotels " & _
                       "WHERE [Hotels.Key] = " & Me.HotelKey
        Set rs = CurrentDb.OpenRecordset(strSQLString)

So this is why I think the problem is something to do with the query being of the parent record of the form.