on exit of field in subform

[Tammy F]

I want to have the user just tab through a field at the end of a list of
items. If the field "itemcmb" is null then exit the subform and go to the
"total" field on the main form.

This works. Sort of. If I am in the subform - it does what I want. But when
I start a new record, or open the form from the main menu - it does not! I
get an error saying something about "Itemcmb" is null and I can't exit now. I
tried error trapping (to the best of my ability) but why is that on exit
event even reading when I first open the main form anyway?

 

[Jeanette Cunningham]

Tammy F,
a form and subform combination opens with the subform opening before the
main form opens.
That might be causing the error you see.
Post back with the code that causes the problem including the name of the
event that triggers the code.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia