FORMS - Using a selected field????????

0

007clint

HELP! I have been struggling with this for weeks!!

In an Access FORM, I have a drop down LIST BOX.
When you select an item, the item appears in another TEXT BOX.

When you then click on a Command Button, I want it to use the item in a
SELECTION QUERY.

I CANNOT GET IT TO WORK!!!!!!!!!!!! HELP!!!!!!!
 
Z

Zodiacal

in the query builder under the criteria field for that column you want to
filter put: Forms![yourformname]![your textbox name]
 
0

007clint

Thanks SO MUCH!

I was so focused on doing something in the FORM that I didn't even see
that the QUERY that the MACRO ran was the problem!

Thanks again (you don't also know about MsgBox and a module substitute
for it that won't stop the MACRO like MsgBox??).;)
 

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

Top