Access 2000 and Access 2003 inconsistencies

[Baffled]

Hi All,

I'm running a database designed with Access 2000 on a workstation that has Access 2003. The following little piece of code does not work with 2003:

On Double click:

DoCmd.OpenForm "frmLCO", acNormal, "", _
"LCONum = Forms!frmLCOViewingForm!subfrmLCOView!LCONum"

When the field is double clicked, frmLCO opens up but to a new record and not the desired record like it does with previous versions of Access.

Does anyone know why and are there any other little quirky inconsistencies I'm not aware of. Please advise.

Baffled

 

[Jack Cowley]

I don't have 2003 but try this syntax:

DoCmd.OpenForm "frmLCO", acNormal, , _
"[LCONum] = " & Forms!frmLCOViewingForm!subfrmLCOView.Form.LCONum

hth,
Jack

 

[Baffled]

That worked perfectly!
(I made a little change)

DoCmd.OpenForm "frmLCO", acNormal, , _
"LCONum = Forms!frmLCOViewingForm!subfrmLCOView.Form.LCONum"

Thanks a lot!

Baffled