When creating a button to open a form, how can I link multiple....

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

Guest

When creating a button to open a form, how can I link multiple fields that
looks up matching data?
 
John Vinson said:
Please explain your question. "Link" multiple fields? What are you
looking up from where?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...
Well, when using the create button wizard, the wizard only allows me to link
one field with matching data using the "<->" button. My question is how can I
take multiple fields and link them together?
 
Use the AND operator

DoCmd.OpenForm "MyForm", , , "[thisField]=" & me.thiscontrol & " AND
[thatField]=" & me.thatcontrol & " AND [theotherField]=" &
me.theothercontrol

B Comrie
http://www.codewidgets.com


"Multi-link command button" <Multi-link command
(e-mail address removed)> wrote in message
news:[email protected]...
 
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

How to use multiple command button to copy user form data to multiple worksheet 0
Pop-up form that creates record that links 1:1 to main form 0
Access linking new student form to new course form 2
Access 2010 Report Button 0
Is it possible to have a button provide a users with more than 1 choice in access? 0
Excel shortcut options 0
How to finding student Rank and How to upload bulk marks of each student at a time. 1
Oversensitive touchpad on modern laptops 0

Back
Top