Run-time error 3075 with where condition

[Tadynn]

I'm getting the following run-time error with my form.
Run-time error '3075'
Syntax error (missing operators) in query expression 'Exceed Order No = 1000008270'.

Basically I've created two forms, one form contains a list called "results". When the user doubleclicks on a line in the list, it's suppose to open up another form and only only show the record that the user has selected. Below is my VB code and other relevant properties pertaining to it.

Here is the code:


Private Sub Results_DblClick(Cancel As Integer)

DoCmd.OpenForm FormName:="TimeSlot_frm", _
WhereCondition:="Exceed Order No = " & Me.Results


End Sub



Here are the form properties:

Form with the list:

Form Name = Lookup Orders
List Name = Results
Field used for link = POKey (1st field in list)
No of fields in list = 8


The linked form properties:

Field used for the link = Exceed Order No
Field type = textbox


Obviously, even though they're name differently, the POKey and the Exceed Order No are the same field.

One thing that I thought is that I would have to declare in the statement, what position the POKey field was in the list. Is this correct? or am I way off the mark.


Thanks, Tadynn.

 

[GingerR]

never seen that syntax before.
have you tried:

Private Sub Results_DblClick(Cancel As Integer)
dim strWhere
strWhere ="Exceed Order No = " & Me.Results
DoCmd.OpenForm "TimeSlot_frm",,strWhere
End Sub

?

 

[Tadynn]

Hi GingerR

I tried that code you wrote. It opens up the form okay, but still doesn't filter it properly.

 

[beetee]

I think you need to bracket the field name, as it contains blanks, e.g.:


DoCmd.OpenForm FormName:="TimeSlot_frm", _
WhereCondition:="[Exceed Order No] = " & Me.Results

To whom it may concern:

FormName:= ...
and
WhereCondition:= ...

are ways of explicitly specifying function arguments.

 

[Tadynn]

Hi beetee

I tried bracketing the Exceed Order No field just as you suggested. However I now get the following error message:

Run-time error '2501'
The OpenForm action was canceled.

and the form doesn't open at all.

 

[kewo99]

If Exceed Order No is a text field you may need to use the single quote character:

WhereCondition:="[Exceed Order No] = '" & Me!Results & "'"

Ken