Query result to textbox

C

Carel Stoop

Plse help

Want to store values from a query (5 fields) on five different textboxes on
a form upon clicking a command button.
Get the query to run upon clicking the button but cannot get values into the
text boxes. Do not want the query screen to open - only the values into the
text boxes

Thanx
 
S

Steve Schapel

Carel,

It sounds like you need to set the Record Source property of the form
to the name of the query, and the Control Source property of the
textboxes to the names of the query fields?

- Steve Schapel, Microsoft Access MVP
 
Top