Using Textbox to query from tables

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

Hi All,


I have an unbound text box and I'll like to use a text box
to do a select statemetn from a table. Is it possible to
program the text box to query from a a table??

Thanks for the help...

mike
 
Mike-

It's not clear what it is you want to do. If you want to look up a single
value from a table and display it in the text box, you can use the DLookup
function in the Control Source of the text box. Enter an equals sign (=)
followed by the call to the DLookup function.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411
 
Back
Top