Opening a form showing only some data

[MartinR]

I wish to open a form in database view showing only the data that has
nothing in the date returned field.

Currently this is the code i have but it is not working.

Dim stDocName As String
Dim stLinkCriteria As String

stLinkCriteria = IsNull([Date Returned])
stDocName = "Returnsform"
DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria


The problem is in the "stLinkCriteria...." line of code. It says the
Database cannot find the field "|" reffered to in your expression. What
code should i use or should i use a filter or a query to do this?

Any Ideas..

Martin

 

[Allen Browne]

Add this line to your code, above the OpenForm line:
Debug.Print stLinkCriteria
You will see that your criteria string does not contain a valid expression.
It will contains something like -1 (the value of True, if the expression is
True) or 0.

Now replace your 3rd line with:
stLinkCriteria = "[Date Returned] Is Null"
and see how you go.

 

[MartinR]

Cheers Allen, That worked perfect. Yet again you come to my rescue.
Thanks