My form for "Overdue Clients" is coming along really well, thanks to those who assisted with my "no record" problem in the subform.
Now! having said that I have had a problem which I spent all weekend trying to resolve without much success. I need to have the form record the date printed into the main table when the user selects the client then hits the "process" button.
I am trying to compare the ClientID in the temporary tblClientSelect table with the TrainingDetails table with the added criteria that the date in the qryOverDue is the same and if so, add today's date to the OverDueLetter field.
To get it to check the two dates by looping through each recordset but it doesn't like:
If tblClientSelect.ClientID = TrainingDetails.ClientID AND
TrainingDetails.[Date of Training] = " & Me![lstClient].Column(2)"
Any suggestions with the syntax - I can post the code if necessary.
Angelique
Now! having said that I have had a problem which I spent all weekend trying to resolve without much success. I need to have the form record the date printed into the main table when the user selects the client then hits the "process" button.
I am trying to compare the ClientID in the temporary tblClientSelect table with the TrainingDetails table with the added criteria that the date in the qryOverDue is the same and if so, add today's date to the OverDueLetter field.
To get it to check the two dates by looping through each recordset but it doesn't like:
If tblClientSelect.ClientID = TrainingDetails.ClientID AND
TrainingDetails.[Date of Training] = " & Me![lstClient].Column(2)"
Any suggestions with the syntax - I can post the code if necessary.
Angelique