Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

filtering a form twice

Status
Not open for further replies.
biscuitboy

biscuitboy

Technical User
Dec 11, 2004
22
0
0
GB
Hiya,

I would like to filter a form called "Authorisors" however I would like to open the form and filter it with the existing filter in stlinkcriteria and also the filter:
"[Workgroup number]=" & "'" & Me![Text162] & "'"

Is this possible??

The code I am using currently to filter one field is shown below:


Dim sotDocName As String
Dim stlinkCriteria As String
stDocName = "Authorisors"
stlinkCriteria = "[Autorisor Usename]=" & "'" & Me![Text67] & "'"
DoCmd.OpenForm stDocName, , , stlinkCriteria

Best Regards and a happy new year
 
Status
Not open for further replies.

Similar threads

huiettcm
  • Locked
  • Question
Catching the Mouse Click Error in Modal User Form
Replies
1
Views
121
strongm
strongm
remeng
  • Locked
  • Question
Row count for table after filtering
Replies
8
Views
393
remeng
remeng
remeng
  • Locked
  • Question
Getting results from a dynamic dimension array
Replies
2
Views
138
Andrzejek
Andrzejek
IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
95
Andrzejek
Andrzejek
kris gersbach
  • Locked
  • Question
I’m importing a csv into a vfp curs
Replies
1
Views
79
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top