Macro not selecting right name

N

nancy

I am using a switch board to open up other forms.
In my switch board I have an unbound combo box that lists names from a query.
I have set up a button that is suppose to bring up a form with the name I
selected . However it is bring up the form with the first person in the
query, not the person I selected.
The form is bound to a table

I think some thing is wrong with my macro.


Participants1, Form, , [Forms]![Switchboard]![CombLast Name], Edit, Normal
 
K

KARL DEWEY

Have tried placing [Forms]![Switchboard]![CombLast Name] in the criteria of
the query?
 

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

Name in table changes 3
Menu driven PowerPoint presentations 0
Setting column width in a table with a macro is not working 0
Menu Macro Not Executing - Need Help 1
Need Help with Macro Security 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Need help modifying code 0

Top