Run time error - 2001

[MaggieLeatherman]

I've been getting Runtime error '2001' , You cancelled the previous operation.... on the following code:

If Not IsNull(Me.BSRId) Then
Me.txtUnits = DLookup("UnitsACM", "GAMaterials", "[bsridfk] = Me.BSRId")
End If

Does anyone know what this means? Thanks, Maggie

 

[JerryKlmns]

Guessing that BSRId is of Text data type

If Me.BSRId & "" <> "" Then
Me.txtUnits = DLookup("UnitsACM", "GAMaterials", "[bsridfk] ='" & Me.BSRId & "'")
End If

 

[TheAceMan1]

MaggieLeatherman . . .

I don't think the code you posted is it. Post the rest of the code! . . .

See Ya! . . . . . .

 

[Zion7]

I think Jerry's got it but, I'm assuming integer (ID)?

Me.txtUnits = DLookup("UnitsACM", "GAMaterials", "[bsridfk] =" & Me.BSRId )

 

[TheAceMan1]

So what happen to [blue]MaggieLeatherman?[/blue]

See Ya! . . . . . .

 

[TheAceMan1]

JerryKlmns, Zion7 . . .

[blue]I've been getting Runtime error '2001' , You cancelled the previous operation....[/blue]

I'm [purple]suspicious[/purple] its something else because this is the kind of error you get when you say . . . open a form or report and in the [blue]OnOpen event[/blue] set the [blue]Cancel arguement[/blue] to True!

See Ya! . . . . . .

 

[Zion7]

AceMan,
I personally wouldn't be familiar with the "OnOpen"
event error, you mentioned but, I've seen it too
many times with the aggregte functions.
Any control typo, or syntatical error will do it.

Give it a try. put in a false control or table name,
or a syntaticaly incorrect criteria statement.

...so the minute I saw the criteria statement,
...If it wasn't this YET, it would be.

 

[TheAceMan1]

Zion7 . . .

Not doubting you at all. Just giving the logic behind my post . . .

See Ya! . . . . . .

 

[JerryKlmns]

TheAceMan1

Well, I was hopping for Maggie to through another exception after my post, (because I dont treat IDs to be of text data type), to reveal the real problematic point just like you said. But where is she?

 

[MaggieLeatherman]

Thanks for all your help! I did have a syntax problem. It's working ok now! Maggie

 

[Zion7]

Maggie, it's usually good practice to reveal the solution
(if it hasn't been already).
Some may still be in the dark, as to where the problem lies, ( I think there are many who follow/search the thread,
without actually interacting)?

 

[TheAceMan1]

MaggieLeatherman . . .

To get great answers and know whats expected of you in the forums be sure to have a look at FAQ219-2884

See Ya! . . . . . .