> I have some queries written in VBA used from reports and forms.  They were working and suddenly are not.  e.g. one  query  that should return a record is not returning a record.  I copied and pasted the query from VBA into the normal query window and it worked fine - returned a record.  Exactly the same thing from within VBA doesn't return a record now - but it used to.
> It is as though something has become corrupted somewhere, but I don't know where nor how to find out.
> Shutting down the machine etc did not cure the problem.
>
> Has anyone seen something like this before?  The only thing I can think of is to reload Access.
> Thanks