Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Change of Record

 
   Windows Help (Home) -> Microsoft Access RSS
Next:  How do I keep my desktop computer from going into..  
Author Message
NickG1

External


Since: Dec 15, 2008
Posts: 1



(Msg. 1) Posted: Mon Dec 15, 2008 7:14 pm
Post subject: Change of Record
Archived from groups: microsoft>public>access (more info?)

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.

 >> Stay informed about: Change of Record 
Back to top
Login to vote
Dirk Goldgar

External


Since: Dec 4, 2008
Posts: 33



(Msg. 2) Posted: Mon Dec 15, 2008 10:36 pm
Post subject: Re: Change of Record
Archived from groups: per prev. post (more info?)

"NickG1" wrote in message

> 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

 >> Stay informed about: Change of Record 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
record locks - I need to check to see if a user has placed a editrecord lock on a record. Is thier a good way to test for a lock. If I know that thier is a lock set then I can do something. Right now I have the form set to no locks. Thanks OD

Creating Multiple Record - I was curious to find out how to create multiple records for an employee. I want to be able to select an employee and schedule vacations and multiple days off from work. Here is what my tables look like: tblEmployee Employee ID (PK) NAME ..

how to create new record automatically - Hi, I have a form a form to show the customer information and I button to create new order for him. The Order form has the following fields: OrderID>>>autonumber cutomerID employeeID …. Also, there is a subform that is bounded on the Order De...

Circumvent "At most one record can be returned by this sub.. - Hi, I have a nested query, in which the subquery can return more than one record, but this is not allowed by Access. I've found various posts where people have gotten the error, "At most one record can be returned by this subquery" and really ...

How to return record counter to the zero position - Hi, I will to restart the record counter in my db. I deleted all records from the db. I tryied to make compact an repair it didn't help. I also triyed in the tables designvy to erase primarykey and write it again it didn't help. Do someone knows how to...
   Windows Help (Home) -> Microsoft Access All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]