Query result to textbox

  • Thread starter Thread starter Carel Stoop
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

result query on a form 1
get query values 4
Execute query from textbox input 3
set value of txtbox in form = select query 2
How to display query result in text box? 1
Query results to listbox 7
Need to show result in message box 1
Query using multiple values from one text box 7

Back
Top