I have a database where people enter new records for people who have attended workshops. I am now adding a form where the user can select a client's name from a drop down box. That is working okay. However, I want the rest of the form to automatically fill in with information already in the record on that client. How do I do this? Many thanks in advance!

James
jsnider@madisoncty.com

Please only post the same query under one category.

Hi James,
Add an unbound combo box to your form header. The record source of this combo should be the same as the one you already have. (To look up a customer name).(I would change the old Combo box to a text field to avoid confusion) Name the new combo box CustomerID2 (just an example) Now add this code to the After Update Event of the unbound combo box.

Docmd.applyfilter,"[CustomerID]=" & me.CustomerID2

Hope this helps a bit.
Marion