help open form invisible

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi every one
any one can help me with this code so that it opens the form invisibe"
invoice register 2005"

Private Sub LTRNO_Exit(Cancel As Integer)
strDocName = "invoice register 2005"
strLinkCriteria = "[LTR NO] = FORMS![Expense Reports].[LTRNO]"
DoCmd.OpenForm strDocName, , , strLinkCriteria
End Sub

thank you
 
Use the WindowMode argument:

DoCmd.OpenForm strDocName, WhereCondition:=strLinkCriteria,
WindowMode:=acHidden
 
In the Load event of your invoice register 2005 form, enter this:
Me.Visible = False
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multi criteria code 2
execute code after pop-up form closes 2
Form/Subform/Command Button to Open Form - Type Mismatch Error 2
Open Subform equal to Main Form Record in Access Project - SQL bac 4
link to microsoft word 4
help with access 2007 , may be filter problem 2
help with this code please 3
Date range from a form 1

Back
Top