Form Filter

[Matt Brown]

Form filter help reqd

This is really starting to bug me, i just can't seem to get the following filter to work.
Everytime i run the code which opens the form i get a parameter query box appear with the customer number in it and the curser waiting for an input.
When i enter the customer number shown it loads the form and displays the correct data.
I think it cannot find the CustomerNo and hence throws up the input box but i can't see why not.

Here is the filter, can anyone see any reason from this or would you need more info:


stDocName = "Tilbud"
stLinkCriteria = _
"CustomerNo = " & Me.CustomerNo & " and " & _
"Dato = " & Me.Dato & " and " & _
"Lobenr = " & Me.LobeNr & " and " & _
"Level <5 "
DoCmd.OpenForm stDocName, , , stLinkCriteria

thanks

Matt

 

[Rich]

CustomerNo is not a valid control name

 

[Matt Brown]

CustomerNo is not a valid control name

You would of thought that but i checked on the tilbud form and the control name is correct CustomerNo

 

[Rich]

Does it work with just
"CustomerNo = " & Me.CustomerNo ?

 

[Mile-O]

What's the data type of all fields involved?