Change of Record

N

NickG1

What event would describe moving from one record to another in a form?

I've incorporated a tab control into my form and I'd like to deisgn it so
that when a user is on any tab other than the 1st one, if the user moves to
another record (e.g., using the record selctor), then I'd like the form to
default to the 1st tab.

I figure I can move the to the 1st tab if I can desctibe the move to a
different record and at then set the focus to a control on the 1st
tab,.......right?

Thanks in advance.
 
D

Dirk Goldgar

NickG1 said:
What event would describe moving from one record to another in a form?

I've incorporated a tab control into my form and I'd like to deisgn it so
that when a user is on any tab other than the 1st one, if the user moves
to
another record (e.g., using the record selctor), then I'd like the form to
default to the 1st tab.

I figure I can move the to the 1st tab if I can desctibe the move to a
different record and at then set the focus to a control on the 1st
tab,.......right?

Thanks in advance.


The Current event fires when the form moves to a new record. You can change
to the first tab page by setting the focus to a control on it, as you say,
or by setting the value of the tab control itself to 0; e.g.,

Private Sub Form_Current()

Me.tabMyTab = 0

End Sub
 

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