I want to open a table to specific records using a drop down box on the form
Posted on 2016-08-10
I have a drop down box on a form that you select a client then I want to push a button that garbs those records in a table and displays them for editing.
The code im using is
dim stLinkCriteria as string
stLinkCriteria = "[Client Name]=" & "'" & Me![SingleAcctName] & "'"
docmd.opentable "Structure", , stLinkCriteria
and Im getting a type mismatch
stLinkCriteria looks like this "[Client Name]='Home Depot'"
what am i doing wrong?