[dba-users] Reading Columns from a subform

[Tommy Pruitt]

Here is some sample code from a macro:
        Dim oForm
        Dim sForm
        Dim oMSRP#
        Dim oQ2#
                
        oForm = oEvent.Source.getModel().getParent()
        sForm = ("ProductsPricing")
        
        oMSRP = oForm.findColumn("msrp_price")
        oQ2 = sForm.findColumn("q2")

"ProductsPricing" is a subform that I want to read "q2" from.
This will work with the "msrp_price" because it is on the main form.
How do I define a variable for the subform and the oEvent statement?

Thanks,
Tommy

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]