troubleshooting Question

& Chr(34) syntax

Avatar of SparkyP
SparkyP asked on
Microsoft AccessMicrosoft Development
4 Comments1 Solution471 ViewsLast Modified:
On a similar line to my previous post. The following code works fine except for our Mr D'Arcy.

I have tried numerous permitations, but cnnot escape an errror message.

Please can you help?

Private Sub Form_Open(Cancel As Integer)
Me.Filter = "[Engname] =" & Chr(34) & Forms!frmdatabaselogin!cboStaffMember & Chr(34) & "And [WE Date] >= Now() - 3"
Me.FilterOn = True

Me.WRSSub.Form.Combo65.RowSource = "select [hours id], [id2], [job number id], [Job Date], site, [Work Request Details], [total ot hrs], [total std hrs], callout from vvworksheetlookup where EngName='" & Forms!frmdatabaselogin!cboStaffMember & "'"
End Sub
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros