We have a form based on and associated with a table.
On the form there is a textbox: txtSubContracted. It's control source is SubContracted (the name of the field in our table). The control source can be selected from the property sheet when designing our form.
We want to put "Yes" in the SubContracted field of our table when certain conditions are met.
The VBA code we run is:
Me.SubContracted = "YES"
The problem - in VBA we get "Compile Error: method or data member not found.
In VBA when we type in Me. the list of available controls that may be selected opens. The control SubContracted does not appear.
So... the control source SubContracted appears in the form design property sheet, but is is not available to select in VBA.
What the heck???????????