I have a form with two text fields bound by a table. I enter data on the
first fields and go to the next field and enter data. I am unable to access
the entered data of the second field unless I tab back to the first field.
Please help. I should be able to enter data on the second field and recognize
that data without going to the first field.
I am making some assumptions here. Your description of the problem does not
specify the exact sequence of events.
I think you are trying to access the new value of field 2 before update has
occured for the field. Update is triggered when you attempt to leave the
field - in your case tab back to field 1.
If your code contains Me.Field2 try Me.Field2.Text instead.
> I have a form with two text fields bound by a table. I enter data on the
> first fields and go to the next field and enter data. I am unable to access
> the entered data of the second field unless I tab back to the first field.
> Please help. I should be able to enter data on the second field and recognize
> that data without going to the first field.