If you must set the forms RecordSource this way then
you must also set the controls such as text box ect. ControlSource = FieldName. Like this:
Private Sub Form_Load
Me.RecordSource = Select * From MyTable;"
Me.txtMyTextBox.ControlSource = "FieldName"
End Sub
I would like to call a sub routine that is in a sub form from the main forms Form_Current event. I have a field that is calculated and I would like to update it when a change to the data has occured on the main form. I am having trouble finding information on this. I tried making the sub...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.