Avatar of Stephen Roesner
Stephen Roesner
Flag for United States of America

asked on 

I want to open a table to specific records using a drop down box on the form

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?
Microsoft Access

Avatar of undefined
Last Comment
Stephen Roesner

8/22/2022 - Mon