Re: NoCurrent record error when calling ReQuery on a subform

Put a debug stop just before that line and run the code. Check the number of
records in rs by entering the commands:

rs.movelast
rs.recordcount

I think that there will be no records in rs. Therefore the error message is
correct. Since you use an OR in your conditional, it's as good as useless
(the record counter is always going to be something other than .EOF OR .BOF)

Anja wrote:
I don't think that this conditional is working the way you want it to:

[quoted text clipped - 48 lines]
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200610/1

Hi,

Thanks for the reply. The recordset is definitely there. It works fine
normally... only when I call ReQuery after the tab change event
happens, that is fails.

The error happens on the line:

MsgBox rs![FormalName]

Thanks,
Anja

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200610/1

.

Relevant Pages

  • Windows Explorer Application Error
    ... Click on CANCEL to debug the program ... If I click on OK, the error message goes away, I'm back to my desktop, all ... I still cannot use any USB ports or optical drives. ... Windows Memory Diagnostic. ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: one or more parameter values are not valid
    ... I'm not sure what you mean "dump the call stack". ... What I posted is what I get when I Ctrl+Break, Debug, at the error message. ... Following these steps usually leads to some piece of information that gives us a clue as to how the code is getting entered illegally. ... My Outlook 2003 VBA code has been generating the following error message for at least several of the 25 users running it for the past couple of months. ...
    (microsoft.public.office.developer.outlook.vba)
  • Re: Unable to download files from the Internet. Please advice.
    ... This will establish an HTTP connection to the ... server is now waiting for further commands, ... then I'm expecting to see an error message and/or code instead. ... Jim ...
    (microsoft.public.windowsxp.security_admin)
  • RE: Exchange System Manager and WMI
    ... Run the following commands from a command prompt in the ... Restart the Windows Management Instrumentation service and all related ... Exchange System Manager and WMI ... symptom was the following error message when attemting to use the Track ...
    (microsoft.public.windows.server.sbs)
  • Error while trying to debug
    ... When I was trying to open one of my ASP projects somewhere else, I got the following error message: ... Check to see that the project has a valid Web.config file, that the Web.config file sets "debug" to true, and that the debug verb is associated with .aspx. ... An error occurred during the processing of a configuration file required to service this request. ... Source Error: ...
    (microsoft.public.dotnet.framework.aspnet.security)