Form to be blank upon opening then choose client form combo box

[lexygirl]

I have an Enter Payments form that I want to be blank when its opened.... I then want to search for a client via a combo box and then view data on that client
Enter Payments Form - Fields - client number, first name, surname


Bookings Subform - Fields - booking id, booking date, booking resource, booking type, booking rate, booking time slot, booking cancelled, client id (FK)
When i choose the client from a combo box then all the above fields get populated. My combo box has these fields - client number, first name, surname and it is in the forms header....
I have tried to put data entry to yes, and the form opens blank but when i pick my client from the combo box no data is populated in the form....
Any ideas would be greatly appreciated

[outhwaik]

Have you tried putting code in the after update event for the combo box to update the other fields? Don't know if that helps or not!

[rpeare]

Make the record source of your form a query that has this as it's criteria in the CUSTOMERID field

forms!<yourformname>!<yoursearchfieldname>

Where yourformname and yoursearchfieldname would reflect the name of you data entry form and the lookup field.

Then in the ON EXIT property of your combo box have the following

me.requery

This will refresh the form with the data from the customer you selected.