Autolookup is not working

H

help!

I followed all the steps to create a query for autolookup, but its not
working. Would it be the fact that the unique field is an autonumber? I find
the customer id on the main form and it populates in the subform. However,
none of the other data populates, first name, last name. Help!
 
O

Ofer

I hope I understood what you trying to do.
If you have a field in your form, unbound field, and you enter a customer
number in and you want all the other fields in the form to refreshed then,
first you need to filter the form recordsource with that field, and then on
the after update event of that field you should write the code me.requery
other wise the records wont refresh
 
O

Ofer

e.g form name MyForm Customer , text box name MyCust, table name CustList
the recordsource for the form will be
SELECT CustList.*
FROM CustList
WHERE CustomerID =[Forms]![MyForm ]![MyCust]

so the recordsource refer to the field, now you just have to bound all the
other field, and refresh the form after you enter a customer id
 
Top