Reference From A Subform

[DMT Dave]

Hi Guy's Can I reference from a subform ?



ie: I have a subform called InvoicesAdd on a Form called frmInvoices

If i am correct, when i try and reference from the subform, effectively it has to be opened yet it is displayed as visible is true ?

but when i reference something, the reference can't find it

So if i have a button on frmInvoices and i want to add and change my criteria and the RecordSource of frmInvoicesAdd then requery it

Forms!frmInvoices!InvoicesAdd.RecordSource = "SELECT......

It can't find it!!

Thank you very much

[Bob Fitz]

Perhaps:
Forms!frmInvoices!InvoicesAdd.Form.RecordSource = "SELECT......

See: http://allenbrowne.com/casu-04.html

[DMT Dave]

Thanks Bob, this works great, i think was using ! instead of .Form

Thank you

[Bob Fitz]

Thanks Bob, this works great, i think was using ! instead of .Form

Thank you

Actually, I think you were missing the "Form."

[DMT Dave]

I am having trouble referencing again on a subform

myCust = Forms!frmInvoices!frmInvoicesAdd!cboCustomer
invNo = Forms!frmInvoices!frmInvoicesAdd.txtInvoiceNumber

Dim invNo As Integer, myCust As String


myCust = Forms!frmInvoices!frmInvoicesAdd!cboCustomer
invNo = Forms!frmInvoices!frmInvoicesAdd!txtInvoiceNumber

Object a Property Doesn't Support This Method

Runtime Error 438

[DMT Dave]

Sorry, Rookie error, had the field named incorrectly !!!!!!!!!!!