On exit property

T

Tammy F

I have a combo box, in a subform, that lists items. I'd like the user to tab
through the combo box field if they are done entering items and have the
cursor move to the main form. Here's the code:
Private Sub RentItem_Exit(Cancel As Integer)
If IsNull(RentItem) Then
DoCmd.GoToControl "[saletaxamount]"
Else
End If
End Sub
Alone- it works fine. However, it is like the on exit property keeps
running. I can't go to an new record.

Error message: Run-time error '2486' You can't carry out this action at the
present time.
When I debug, it goes back to the above piece of code. Is there a better
way? What am I missing? Why does it keep going to that field?
Thank you,
Tammy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top