Work on my comp, but not on another computer 1

[haerion]

Hi all,

I got a query that work on my computer, but when I tried to send the file to a coworker, then the qry was not working. Here is the sql of the query:

SELECT INVDFR2.ST, INVDFR2.ITEMNO1, INVDFR2.DESC1, INVDFR2.DESC2, INVDFR2.PRO, INVDFR2.LSTCOST, INVDFR2.AVGCOST, INVDFR2.[$EIGHT]
FROM [New 8 Price] LEFT JOIN INVDFR2 ON [New 8 Price].Item = INVDFR2.ITEMNO1
WHERE (((INVDFR2.ITEMNO1)=[forms]![Prix 8 Mod].[New8Price_subform]![Item]))
ORDER BY INVDFR2.ST;

The part not working is the :
[forms]![Prix 8 Mod].[New8Price_subform]![Item]

Why would it work on a computer but not on anotehr one?

The new8price_subform is a subform in a datasheet view on my main form "Prix 8 Mod".

We also have the same version of Access 2003.

Regards,

Haerion

 

[haerion]

Is it this hard to solve?

Was thinking of a better formula that would work in ANY case. But I don't have enough knowledge to find one

 

[PHV]

Please, define "not working"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are haerion . . .

Don't know if its the problem but shouldn't the first character of a [blue][blue]field identifier[/blue][/blue] be a [blue]letter character[/blue]?

You have INVDFR2.[[red]$[/red]EIGHT] . . .

[blue][blue]Your Thoughts? . . .[/blue][/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[haerion]

Hi guys

By not working, I mean that the field INVDFR2.ITEMNO1 should return the line selected in my subform.

It does exactly that on my computer, but when I sent the file to my coworker, seem like the query return nothing for him.

It is supposed to return one line depending which item is selected on the subform.

You need more info?

 

[dhookom]

try:

[forms]![Prix 8 Mod].[New8Price_subform].Form![Item]

Duane
Hook'D on Access
MS Access MVP

 

[haerion]

Thanks Duane,

It is working without problem now. I was sure it was something like that

Have a good day!