In order to cut down on redundant typing, I've set field values to default to the values in previous records.
The problem results from one particular value of the combo box cmbProjectType that is supposed to trigger the visibility of a text box (txtMapCopies). I.e., if cmbProjectType = "Maps", txtMapCopies pops open to ask how many copies.
When the form moves on to a new record, the "ProjectType" correctly shows "Maps". The Map Copies box, however, remains invisible.
The code to trigger visibility is in the Current event. When I check out the variable values in the code, the value for cmbProjectType is null, despite the fact that there's an entry in that field.
As soon as I click in the field, txtMapCopies becomes visible.
Any suggestions on this?
thanks!
J
The problem results from one particular value of the combo box cmbProjectType that is supposed to trigger the visibility of a text box (txtMapCopies). I.e., if cmbProjectType = "Maps", txtMapCopies pops open to ask how many copies.
When the form moves on to a new record, the "ProjectType" correctly shows "Maps". The Map Copies box, however, remains invisible.
The code to trigger visibility is in the Current event. When I check out the variable values in the code, the value for cmbProjectType is null, despite the fact that there's an entry in that field.
As soon as I click in the field, txtMapCopies becomes visible.
Any suggestions on this?
thanks!
J