Form - Text Entered,Query,Records Displayed

  • Thread starter Thread starter The Boondock Saint
  • Start date Start date
T

The Boondock Saint

Is there a way I can have a text field on a form, where i can enter a
variable.... such as say "Rabbits"
that will then query a field in a table for any records that have that
wording in it... and then those results will show up on that same form in
say a drop down list, or alternative display methord...

in a query ive got Like "*" & [Search Which Word?] & "*"

But id like it to take the variable from a text field on my form..... Id
also like it so that when i click on a record from the dropdown list or
display,, it then opens that record in that form......

Ideally... id love to have a tabbed setup, where the first page is a search
page, and the other pages display the record information? can this be done?
or am i dreaming ?

Cheers The Saint
 
Try:

Like "*" & [Forms]![YourFormName]![YourTextBoxName] & "*"

If you want a tabbed form just use the search query's textbox on the first
tab and the rest of the form (based on the same query) on the subsequent
tabs.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top