hi all, I need some help here on referring to controls on a tab page control.
This tab page control is on a form (Form4), where the only main control is a unbound combo box that allows the user to select a serialno. Once a serialno is chosen, some of the fields on the tab page will be automatically filled with entries. The underlying table I used for Form4 is "Parts_For_repair".
On the 2nd page of the tab control, I have used an option group (TypesOfRepair) that displays all the types of repair that we have. Some egs include WarrantyRepair, OutOfWarrantyRepair..... Once a user click on either one of these types of repair, i want this record to be saved into another table "Repaired_Parts". But I have problems referencing to these controls on the tab page control.
I've written an event procedure for one of the check boxes in the option group. This is shown below:
Code:
Private Sub chkWarranty_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
MsgBox "updating warranty repair"
Dim stDocName As String
stDocName = "Query23"
DoCmd.OpenQuery stDocName, acViewNormal, acEdit
End Sub
Query23 looks like this:
Code:
UPDATE REPAIRED_PARTS AS R SET R.WARRANTYREPAIR = [FORMS]![FORM4]![CHKWARRANTY].VALUE
WHERE R.SERIALNO=[FORMS]![FORM4]![CBOSERIALNO].VALUE;
The serialno is unique to identify any tuple. The result of this event returns nothing...I've tried to print out the value of chkWarranty using Debug.print me.chkwarranty.value but there's an error and it's returning me nothing..
I gather this error has something to do with the way i reference the control on the tab page cos i tried to insert a checkbox on the main form (that is, outside the tab control), everything works fine.
Pls help.
Thanks.
Rgds,
Tracy
ASP Free Forums Sponsor:
March 16th, 2004, 12:24 AM
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
