Passing two values to a form

A

Andrew Wilkins

I know how to pass one value to a form using a button:

stLinkCriteria = "[DepartmentAllocation]=" & "'" & Me![Combo142] & "'"

But how can I change this code to pass two values? For example, I want to
pass not just the DepartmentAllocation value but also the CustomerName value.
Both are from combo boxes called Combo142 (for DepartmentAllocation) and
Combo152 (for CustomerName) respectively.

Can this be acheived?
 
A

Allen Browne

Assuming that the Bound column of both combos refers to a Text type field:

stLinkCriteria = "([DepartmentAllocation]=""" & Me![Combo142] & _
""") AND ([CustomerName] = """ & Me.Combo152 & """)"
 

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

Combo Box/Select all 4
Calculate the median value before a specified list 0
filter on combo box possible? 1
Incomprehensible OpenArgs behavior 2
Trouble passing value to new form 2
Pass field value selected in Combo Box to SQL Query 7
Linked Forms Unlike Form/Subforms in Not Passing Primary Key Value 8
Pass a Report Value to a Form? 3

Top