Tab control question

[Debbiedo]

I had the following code for a field originally located in the details
section of Access 2003. I decided I needed to use tab cointrols. When
I cut and pasted the field and its associate code 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]

Is the code actually firing? Just because you copied the field and the code
doesn't necessarily mean that the Change property will be correctly set to
[Event Procedure].

 

[Debbiedo]

Is the code actually firing? Just because you copied the field and the code
doesn't necessarily mean that the Change property will be correctly set to
[Event Procedure].

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)

I had the following code for a field originally located in the details
section of Access 2003. I decided I needed to use tab cointrols. When
I cut and pasted the field and its associate code 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- Hide quoted text -

- Show quoted text -

Right you are. At first on the the properties box, the change event
procedure did not contain any code even though it appeared in the VB
editor. When I checked just now, it was part of the event procedure
and worked. I don't know what I did to get it to suddenly recognize
the on change event procedure for that field, but hey, it works now.
Strange. Thanks.