Select DB

[Arsench]

Hi all,
my question is about select few db in one query but with form and button click.example

have a table1 table2 table3 and in the access form have a textbox1 textbox2 textbox3 how can i do with button click select data from db

exmpl. name(from table1) = textbox1 age(from table2) =textbox2 address(from table3) =textbox3

thanks

 

[Dennisk]

to select a name from table using a criteria from a form set up a reference in the query criteria grid useing :

Forms!YourFormnameHere!TheNameofTheControlOnTheForm

The form must be open for this to work.