Getting data from a form instead of a table
Posted on 2011-05-09
I have a form that displays a box with values taken form a table with a field named [Works Order No].
The box is locked and the only way to change it is to use ‘Find’.
If a user searches for a value then it is successfully displayed in this box.
I have used the OnLoad event as me.Works_Order_No to initially read what value is in the [Works Order No] field. This works OK.
Once the form is loaded AND the user uses 'Find' to get a new value for [Works Order No] the new value is successfully loaded in to the box but I cannot read it with VBA.
That is the value me.Works_Order_No remains ‘out of context’ ( in the watch window).
In VBA, how can I get the value out of a box on my FORM once it is loaded?