Opening a form Problem

[Bob V]

What code would I need to open this form from another form

Private Sub subDistribute()
Me.Caption = "Distribute Through Owner.."


lbHodingInvoices.Caption = "Holding Invoices"
lbDistribute.Caption = "Distribute"
fraModify.Visible = True
fraInvoices.Visible = False
fraModify.value = 2

Thanks for any help...........Bob

 

[pietlinden]

What code would I need to open this form from another form

Private Sub subDistribute()
Me.Caption = "Distribute Through Owner.."

lbHodingInvoices.Caption = "Holding Invoices"
lbDistribute.Caption = "Distribute"
fraModify.Visible = True
fraInvoices.Visible = False
fraModify.value = 2

Thanks for any help...........Bob

DoCmd.OpenForm "FormName"...? or did I miss the obvious?

 

[Tom van Stiphout]

On Sun, 28 Oct 2007 11:41:27 +1300, "Bob V" <[email protected]>
wrote:

The most practical way to open a form is:
DoCmd.OpenForm "some_form_name"
Look it up in the help file.

-Tom.

 

[Bob V]

Thanks Tom , I tried that first!
Normally the only way I can get to the form is to click this control
Private Sub cmdModifyIntermediateInvoice_Click()
DoCmd.Close acForm, "frmModify"
DoCmd.OpenForm "frmModify", , , , , , "ModifyHoldingInvoice"


End Sub

Then select the toogle to get to the form "Distribute Through Owner.."
Thanks for the help............Bob