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

  • Thread starter Thread starter 007clint
  • Start date Start date
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!!!!!!!
 
in the query builder under the criteria field for that column you want to
filter put: Forms![yourformname]![your textbox name]
 
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??).;)
 
Back
Top