Help with Query input to text box

[hawg1]

Hi,

I haven't dabbled with queries much and am at a standstill. I have a table called Personnel. Another table is called evaluations that is related to personnel via a primary key, SSN. this is where the evaluations date is entered based on the SSn selected.

On a form is a combo box to select a specific individual. Once the individual is selected, a subform appears, based on the table peronnel with a text box for last evaluation date. I wish to have the latest evaluation date, based on the selected individual, inserted into the text box on the subform.

I have created a query that looks at the entire table evaluations and returns the latest evaluation date. But it just returns the latest evaluation date regardless of who it is. I need to populate the last evaluation date textbox with the latest evaluation date for the idvidual selected in the combo box. Any help would be appreciated.

Thanks

 

[hawg1]

Hi Again,

After more fiddling and several forum searches, I figured it out. Just needed an independent query and a Dlookup to run the query and save as a variable. It may not be pretty, but it does what I need it to do.