Re: Requery('viewname')

Hi,

Let me update you further on this. With regards to Modal form, it does
happens but only when you do a REQUERY() in a very fast way. What I have here
is master records with three child tables so if I change the record position
in the master table the child records with be REQUERY() accordingly.

Thus if I change the master record in a split second the REQUERY() will
return -1 too although not as obvious as Modeless form.


"Mark McCasland" wrote:

> Does the SELECT command used to create the view have any functions like
> TRIM() for any of the fields being selected? If so, the problem could be a
> "base table structure change" type of error. Does AERROR() return any more
> information?
>
> "Eric Lim" <EricLim@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:97595292-0285-497B-8EBA-8CE09F1A5628@xxxxxxxxxxxxxxxx
> > Hi All,
> >
> > Any idea what is the problem if the Requery() returns -1 instead of 0 or
> 1?
> > There is no documentation to explain what was the problem if Requery()
> return
> > -1
> >
> > --
> > Eric Lim
>
>
>
.

Relevant Pages

  • Re: Requery(viewname)
    ... With regards to Modal form, ... >> is master records with three child tables so if I change the record ... >> in the master table the child records with be REQUERY() accordingly. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Requery(viewname)
    ... > local laError, lcError, lnI ... >> and post the error info so we can try to see what is happening. ... >>> does happens but only when you do a REQUERY() in a very fast way. ... >>> What I have here is master records with three child tables so if I ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Need a way around opening form in acDialog mode
    ... If the reason you are using a modal form is to run the requery after the ... Ragnar ...
    (microsoft.public.access.forms)
Loading