Links form by using Date field

[2101]

Hi, I am creating a link between form by using two fields in the link criteria one of the field is a date filed
Below are the code - ...

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmTotalActivity"
stLinkCriteria = "[activityNo]=" & Me![cboActivityNo] & " And [dateFrom] = " & Me![txtDateFrom]

DoCmd.OpenForm stDocName, , , stLinkCriteria

I know these have to do with using # but I have not had any success to find out where I should use #....
Please Help
jg

 

[scking]

try:

stLinkCriteria = "[activityNo]=" & Me![cboActivityNo] & " And [dateFrom] = #" & Me![txtDateFrom] & "#"

or you may have to do this since the value in the text field is a string and not a date:

stLinkCriteria = "[activityNo]=" & Me![cboActivityNo] & " And [dateFrom] = #" & CDate(Me![txtDateFrom]) & "#"

Steve King Growth follows a healthy professional curiosity