Simple list/combo search fails

[Dega]

I am using the wizard to create a simple record search on lastname/firstname (tblCustomers)

Problem is when a subform (tblBookings) is on the page the search will not work period.

I know it's related to the subform being there but don't know the reason.



Thanks

[llkhoutx]

Post the design views of tblCustomers & tblBookings and the properties for your combo box.

You've provided insufficient information to help.

[Dega]

Thanks for replying ...

I have included the design view of tblCustomers & tblBookings (subform).

Have made several attempts to use the wizard and then tried a sql query without using a wizard. I do have limited sql background but little with the access interface.

[llkhoutx]

Attached is the table relationships (without all fields). Your view will have all fields.

To filter tblBookings by CustomerID, start with a query in the design view, see jpg.

To see the SQL just looki at the query in the SQL view.

SELECT tblBookings.BookingID, tblBookings.CustomerID
FROM tblBookings
WHERE (((tblBookings.CustomerID)=[forms]![YourMainformName]![CustomerID]));

Of course, add the columns you desire to the tables and to the query.

This ought to give you a running start.

[Dega]

Thank you for the advice and illustration.