Text Box Lookup

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

Guest

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
 
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]
 
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.
 
Back
Top