Open Form addition

[Bob Vance]

This is part of my code on my OpenForm , can [frmZeroAmountHolding] be added
to this code as I have the same List Box lstModify on that form as
well........Thanks for any help......Bob

recInvoice_ItMdt.Open "SELECT * FROM tblInvoice_ItMdt WHERE
IntermediateID=" _
& Nz(Form_frmMain.lstModify, 0) & " AND HorseID=" _
& Nz(Form_frmMain.lstModify.Column(1), 0),
CurrentProject.Connection, adOpenDynamic, adLockOptimistic

 

[Tom van Stiphout]

On Mon, 6 Oct 2008 22:23:31 +1300, "Bob Vance" <[email protected]>
wrote:

Rather than uing Form.Control syntax, you can use:
Forms(strMyFormName).Controls(strMyControlName)

-Tom.
Microsoft Access MVP