Joshua B
lists at jbsolutions.com.au
Tue Dec 30 14:49:12 CST 2003
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=Forms!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