populating text boxes from the result of a query

[cooper]

oh well search capability is required so i guess i will stick with it.

one issue: There will be different users entering the data on the same date. When I add records in the main table with a different employeeId, the date repeats itself in the combo box AND the combo box doesn't work for any dates then - The only way it works again is when I delete all the records and enter new data again.

How can I show the date and the records only for that user? I'm attaching the database here so you can see it as well.


thanks again!

[June7]

Change the RowSource sql for the date combobox to:
SELECT [tblActivities].[dte], [tblActivities].[ActivitiesID] FROM [tblActivities] WHERE EmployeeID = Forms!frmEmployees![EmployeeID];

[cooper]

thanks June7 - you have been of great support. I just marked it as solved!