G Guest Dec 4, 2003 #1 Does anyone have an idea on how to open 1 form based on the contents entered into a textbox on another form. Any help is greatly appreciated Thanks
Does anyone have an idea on how to open 1 form based on the contents entered into a textbox on another form. Any help is greatly appreciated Thanks
F fredg Dec 4, 2003 #2 Gregory said: Does anyone have an idea on how to open 1 form based on the contents entered into a textbox on another form. Any help is greatly appreciated. Thanks Click to expand... Do you wish to open the form at a certain record? Check Access help on using the where clause argument of the OpenForm method. DoCmd.OpenForm "FormName", , ,"[IDField] = " & Me![ControlName]
Gregory said: Does anyone have an idea on how to open 1 form based on the contents entered into a textbox on another form. Any help is greatly appreciated. Thanks Click to expand... Do you wish to open the form at a certain record? Check Access help on using the where clause argument of the OpenForm method. DoCmd.OpenForm "FormName", , ,"[IDField] = " & Me![ControlName]
D Dave Dec 4, 2003 #3 You can use a button for example with code such as docmd.openform Me.textboxname.value, acNormal,,,acFormEdit, acWindowNormal lookup the help for the openForm method to know what other arguments you can use -----Original Message----- Does anyone have an idea on how to open 1 form based on Click to expand... the contents entered into a textbox on another form.
You can use a button for example with code such as docmd.openform Me.textboxname.value, acNormal,,,acFormEdit, acWindowNormal lookup the help for the openForm method to know what other arguments you can use -----Original Message----- Does anyone have an idea on how to open 1 form based on Click to expand... the contents entered into a textbox on another form.
