Link form to Access query result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to have the rowsource of a list box in a form be the result of
an access query.
Same question regarding a TextBox.

Many thanks,
Dan
 
List box: Yes. Just go to the properties of the List Box, Data tab, Row
Source. Click the dropdown box near the end of the line to select an existing
query or use the ellipsis (...) at the end of the line to build the query.

Text Box does not have a Row Source; perhaps you meant Combo Box? If so,
same procedure as above.
 
Oops. Sorry. I thought I was in the Access programming forum, not the Excel
forum when I posted my response, so my comments were Access-related.
 
It's ok, I'll post it again, thanks anyway

Brian said:
Oops. Sorry. I thought I was in the Access programming forum, not the Excel
forum when I posted my response, so my comments were Access-related.
Click to expand...
 
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

Link Excel form to Access query result or any other ADO 2
HELP: Auto Populate Excel Userform fields from access query result 3
Access Access Report Works on One Machine but not Another 3
Duplicates in union query 3
Access Print Files from Query Results 0
How to finding student Rank and How to upload bulk marks of each student at a time. 1
Chart in tabbed form goes blank on records source change 0
Access Determine what query to run based on a checkbox 0

Back
Top