Open form criteria 2

[mayday999]

Hi all,

I have code to open a form and I am trying to pass two criteria to open the form. I keep getting syntax errors. here is my link criteria:

stLinkCriteria = [("[Site_ID]=" & Me![Site_ID]) And ("[AssessmentID]=" & Me![List38])]

Can anyone help with this?

TIA

D

 

[PHV]

Perhaps simply this ?
stLinkCriteria = "Site_ID=" & Me!Site_ID & " AND AssessmentID=" & Me!List38

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[straybullet]

If both Site_ID and AssessmentID are numeric, this should work:

"[Site_ID]=" & Me.Site_ID & " And [AssessmentID]=" & Me.List38

If say Site_ID is text and AssessmentID is numeric:


"[Site_ID]='" & Me.Site_ID & "' And [AssessmentID]=" & Me.List38

Let them hate - so long as they fear... Lucius Accius

 

[straybullet]

well damn im slow...

Let them hate - so long as they fear... Lucius Accius

 

[mayday999]

Thanks PHV,

Went a little crazy with the brackets and quotes...lol