QUOTE (TechSteff @ Nov 5 2010, 11:05 AM)
Thanks for the reply, but I didn't explan the situation well enough. I have two combo boxes and based on the value of two combo boxes I would like to a query to populate the textbox, for example if Combo1. is Lastname and Combo 2 is Name I want a query to populate the textbox with that persons birthdate something like that...
Pardon me for jumping in but that description could still use a little more detail. In fact, it's quite possible that we might recommend you to change your form's design. For example, let's say that the first combobox is showing "Smith" and the second combobox is showing "John." What if you actually have more than one "John Smith" in your database? Who's birthday would you want to show up in the textbox?
Just my 2 cents...
EDIT: I guess the point I am trying to make here is that we need to get you into the habit of using Primary Keys. They are the only way to ensure we are working on a specific record.