Relist of earlier question

[jason]

I have 2 tables as follows
SSN--------SSN
Name Date Tardy
Phone
etc

I have a form created using the first table as the
source. I would like a combo box that will display the
tardy dates for each record. I first created my combo
box using date tardy as the record source which populated
the combo box with every date in the table. I then
modified the statment to the following:

SELECT [tblTardies].[ID], [tblTardies].[Date Tardy] FROM
tblTardies WHERE [SSN]=[Forms]![frmEmployees].[SSN];

The combo now shows the correct values, but only when the
form is first opened. When I page to the next record,
the combo retains the information from the previous
record, and does not update. Is there a fix for this
situation???

Thanks,
Jason

 

[chris]

Try putting the code

YourCombo.requery

in the form current event

 

[jason]

Thank you very much. That did it.