Link form to Access query result
 

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

Link form to Access query result
 

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.

"Dan" wrote:

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

Link form to Access query result
 

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.

"Dan" wrote:

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

Link form to Access query result
 

It's ok, I'll post it again, thanks anyway

"Brian" wrote:

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.

"Dan" wrote:

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