Access 2003 Query Issue

[randaj]

Have a simple query that works on Access XP and 2000 but does not on 2003. Any known issues?

 

[Cagliostro]

how simple is your query?

Ion Filipski

 

[randaj]

Like [forms]![swbMain]![frmreports]![cboCompound]

On XP and 2000 pulls the correct data, 2003 pulls nothing.

 

[Cagliostro]

I believe there is osmething with configuration or version of MSAccess you're running under Win2003

Ion Filipski

 

[randaj]

I'm talking about Office 2003 versus Office XP and 200.

 

[RoyVidar]

Hi!

Could you perhaps try:

[tt][forms]![swbMain]![frmreports].Form![cboCompound][/tt]

Form keyword to tell Access frmreports is a subform, which I assume it is.

Roy-Vidar

 

[evalesthy]

Are you getting an error message, no data returned, or wrong data returned? Can you supply more details.

 

[randaj]

No errors, just no data.