Command Button

P

Pass-the-reality

I used the wizard to create a command button so that when it opens my form
(frmCallLog), it will only show records where UserID and Text28 are the same.
How can I expand on stLinkCriteria = "[UserID]=" & "'" & Me![Text28] &
"' " to also so And [Status] = Me!Text25
 
J

John Spencer

stLinkCriteria = "[UserID]='" & Me![Text28] & "' And [Status] ='" &
Me!Text25 & "'"


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 

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

VBA Code Help 12
Key Violation message 5
Command Button 1
view specific forms 1
View Specific Records within a form 1
Code to open a query 2
transfer a field using button 1
Linkcriteria for drag a conbobox information 9

Top