Text Box Lookup

[Gregory]

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

 

[fredg]

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

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]

 

[Dave]

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

the contents entered into a textbox on another form.

 

[Gregory]

Thanks....worked perfectly