G Guest Nov 22, 2004 #1 When creating a button to open a form, how can I link multiple fields that looks up matching data?
J John Vinson Nov 22, 2004 #2 When creating a button to open a form, how can I link multiple fields that looks up matching data? Click to expand... 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
When creating a button to open a form, how can I link multiple fields that looks up matching data? Click to expand... 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
G Guest Nov 22, 2004 #3 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?
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?
B B. Comrie Nov 22, 2004 #4 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]...
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]...
