[AccessD] Access 2003 issue

Thanks Joshua - I got to the bottom of it ... eventually.  I have queries which reference fields on a Form as criteria (criteria:Forms!Form1!field1).  Many of these fields are on sub-forms, in fact worse than that, subforms of a form which is the Page in a Tab Control.

Access 2003 queries seem to be extremely fussy how you reference these fields.  You must have the precise syntax.  So, where this worked previously  
  (Forms!MainForm!SubForm!Field), now I must have
  (Forms!MainForm!SubForm.Form!Field) 
in order for the queries to ReQuery correctly in 2003.

The new syntax also works in A2000.

Stephen Bond


> -----Original Message-----
> From: Joshua B [mailto:lists at jbsolutions.com.au]
> Sent: Wednesday, 31 December 2003 9:49 a.m.
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Access 2003 issue
> 
> 
> Hello Stephen Bond,
> 
> I wrote in a week ago with a similar problem (the thread was 
> titled "Calculated Field Error A2003" if you want to have a 
> look). One workaround (which I'm still not really happy 
> about, but seems to alleviate the Me.Requery problem) was to 
> use the syntax Me.Recordsource = Me.Recordsource, this seems 
> to work the same as a requery, minus the errors. Another 
> thing to look at is unchecking all the references, 
> compacting, and then rechecking them again. I havent had a 
> chance to try this one as yet, because my client is on 
> holidays, and I dont have A2003. The way it's looking at the 
> moment, I think I'll be doing my best to steer clear of 2003 
> for a while. If you try the reference refreshing option, 
> could you let me know how you go? Thanks.
> 
> ======= At 2003-12-31, 05:48:00 you wrote: =======
> 
> >I have an app that is Access 2000 MDB and it runs fine under 
> both A2000 and A2002, in A2000 format. 
> >
> >Today I loaded it to run under Access 2003 and there is a 
> problem.  It appears that the syntax 'Me.Requery' does not 
> work.  The Me.Requery is in the After_Update event of a combo 
> that serves to filter the records appearing on the continuous 
> form.  The form's RecordSource is a query with the combo 
> boxes referenced like this:
> > 
> >Field:IIF(IsNull(Forms!etc!cboFilter),True,underlyingField=Fo
> rms!etc!cboFilter) 
> >Criteria:True 
> >
> >I can't see anything in KB.  Because the combo is on a 
> subform of a form that's part of a Tab control, I'm going to 
> mess around with the way the combo is declared in the Query, 
> but this is shootin' in the dark stuff. 
> >  
> >BTW, I tried converting the app to Access 2003 format, but 
> nothing changed, the problem still exists.
> > 
> >Any ideas?  TIA 
> >
> >
> >Stephen Bond 
> >Otatara, South Island, New Zealand 
> >_______________________________________________
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
> 
> = = = = = = = = = = = = = = = = = = = =
> 			
> 
> Best regards.				 
> Joshua B
> lists at jbsolutions.com.au
> www.jbsolutions.com.au
> 2003-12-31
> 
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>