Tab control question

  • Thread starter Thread starter Debbiedo
  • Start date Start date
D

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
 
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].
 
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". )
Click to expand...
Private Sub SCHOOLSN_Change()
SN_SCHOOL = SCHOOLSN.Column(0)
Me.Requery
End Sub
Click to expand...
Any ideas why? I am new to using tabs and VBA codiong.
Click to expand...
Thanks for any help.
Click to expand...
Deb- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

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.
 
Back
Top