syntax help, please?

[WinDancer]

I want to take a field from an open form and change a value in the underlying table based on that date-

Table.tblClassSurvey.period.setvalue=Forms!frmTabSurvey!CompletionDate

The form field is a ShortDate
The table field is just the yyyy-mm datepart

Thanks,
[Down to 2 paydays left before retirement]
Dave

 

[SOS]

Is tblClassSurvey part of the form? Or are you trying to update a different table?

 

[WinDancer]

tblClassSurvey is the table I want to update from the form

 

[SOS]

Then create an update query which can use the value on the form to update the particular field/record in the table.