Problem in On Click

R

rangerruss

Registered User.

Local time

Today, 18:17

Joined

Feb 12, 2009

Messages

11

• May 16, 2010

• #1

I have a database which contains various case numbers (case #) in the format as "D10-04-1234".

I want to be able to click on the case # field in the form so that a new form named "incidents" will open for the above stated format.

here is my code which does not work..

Code:

Private Sub Case___Click()
    Dim stDoc As String
    Dim stLinkCriteria As String
    
       stDoc = "Incident Report"
       stLinkCriteria = "[case #] =" & Me![Case #]
       DoCmd.OpenForm stDoc, , , stLinkCriteria

End Sub

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 15:17

Joined

Aug 30, 2003

Messages

36,274

• May 16, 2010

• #2

Your data is text, which requires a little different syntax:

http://www.baldyweb.com/wherecondition.htm

 

R

rangerruss

Registered User.

Local time

Today, 18:17

Joined

Feb 12, 2009

Messages

11

• May 16, 2010

• #3

thank you for the quick response.....i dont know how i missed that.....