Show records for each date

[cooper]

Hi,

I have a subform with many text boxes - these text boxes are supposed to show the different fields in the original table.

What I want to do is - let the user select a date from a combo box, and as the user selects a particular date, the text boxes are all populated. Also, the user should be able to edit these text boxes and save the changes without having to add new record (over writing data).

A new record is only added if a new date is selected. I have a query (mainquery) with the following SQL that shows the values I want, but how do I use the result to populate these text boxes:

SELECT Table2.Date, Table2.Employee_ID, Table2.[Caseflow Shelving Available], Table2.[Caseflow Shelving Actioned], Table2.[High Cube Available], Table2.[High Cube Actioned], Table2.[Prewab Report Available], Table2.[Prewab Report Actioned], Table2.[Run to Zero/Frozen Availabl], Table2.[Run to Zero/Frozen Actioned]


FROM TblEmployees LEFT JOIN Table2 ON TblEmployees.Employee_ID = Table2.Employee_ID;


I would really appreciate if someone can help me out here -

I can post the sample database if someone would like to have a look.

Thanks!!

[orange]

You should not use names with embedded spaces or special characters. These will cause you more grief as you proceed.
You should not use the name Date as one of your fields. Date is a reserved word with special meaning in access.

Can you post a picture of your tables and relationships?

[cooper]

oh i see! I will change it!! thanks!

i am posting the database here - It would be great if you can have a look and guide me somewhere.

thanks again for taking out your time to help!!!