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

[Multi-link command button]

When creating a button to open a form, how can I link multiple fields that
looks up matching data?

 

[John Vinson]

When creating a button to open a form, how can I link multiple fields that
looks up matching data?

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

 

[LL Cool A]

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

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?

 

[B. Comrie]

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
[email protected]> wrote in message
news:[email protected]...