B
Bob Vance
I have a sub form that I want to also use to open my Invoice as well,
tbInvoiceID is the text box with the InvoiceID
Can this be added to the code below
frmOverviewClient.subfrmOverviewClient.tbInvoiveID
-------------------------------------------------------------
Else
recInvoice.Open "SELECT * FROM tblInvoice where InvoiceID=" &
Form_frmModifyInvoiceClient.lstModify.value _
, CurrentProject.Connection, adOpenDynamic, adLockOptimistic
subShowInvoiceValues
subShowInvoiceDetailValues
tbInvoiceID is the text box with the InvoiceID
Can this be added to the code below
frmOverviewClient.subfrmOverviewClient.tbInvoiveID
-------------------------------------------------------------
Else
recInvoice.Open "SELECT * FROM tblInvoice where InvoiceID=" &
Form_frmModifyInvoiceClient.lstModify.value _
, CurrentProject.Connection, adOpenDynamic, adLockOptimistic
subShowInvoiceValues
subShowInvoiceDetailValues