Tab control question

[Debbiedo]

I had the following code for field originally located in the details
section of Access 2003. I decided I needed to use tab cointrols. When
I cut and pasted this into my tab, it stopped working. (The tab
control is called "Page1". )

Private Sub SCHOOLSN_Change()
SN_SCHOOL = SCHOOLSN.Column(0)
Me.Requery
End Sub

Any ideas why? I am new to using tabs and VBA codiong.

Thanks for any help.

Deb

 

[Douglas J. Steele]

Already answered in another newsgroup to which you posted the same question.

If you feel you need to post to more than one group (HINT: it's seldom
necessary), please have the courtesy to cross-post (send the one message to
all groups at once), rather than multi-post (send individual messages to
each group). In this way, all responses to your post will be available
together, regardless of what group the responder was in, and the rest of us
won't have to read your post multiple times. (It also uses fewer server
resources)