Hi
I have a form with a textbox (txtCSD) that I'd like to display a field within a subform - "[start date]" and this should change when a new record is selected in the subform
I can do this via a Control Source, however this locks the textbox and users cannot overwrite the value.
This code produces an error "MS Access can't find the field '1' referred to in your expression"
Much appreciated
I have a form with a textbox (txtCSD) that I'd like to display a field within a subform - "[start date]" and this should change when a new record is selected in the subform
I can do this via a Control Source, however this locks the textbox and users cannot overwrite the value.
Code:
Private Sub Form_Click()
Forms!increase!txtCSD = [dbo_resources9].[Form]![Start Date]
End Sub
This code produces an error "MS Access can't find the field '1' referred to in your expression"
Much appreciated