[AccessD] Microsoft Access Has Stopped Working

I have run into that myself.  I am convinced (in fact I know that) there is "hidden stuff" in what 
we edit.  I think it is probably something similar to the old Word Perfect control codes - "hidden 
but there none the less".  If you cut and paste - guess what - it survives.  *NEVER* cut and paste 
the offending line.

Comment out the offending line.
Drop down a new line
*type the offending line in manually*

If it is the same thing that I ran into, it will be gone.

DELETE the commented out offending line so that it is never uncommented.

I believe that you can cut and paste the offending line into NotePad.  Doing so strips all the 
special unseen stuff out of it.  Then cut from Notepad and paste back in to your module.

It is really best though to just manually type the line in again.

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 8/3/2012 10:46 AM, Rocky Smolin wrote:
> Okay - closer to a solution to one of the problems - I have traced the
> problem to one line of code:
>
> Me.cboSOHeader.Requery
>
> This combo box has all the sales orders in it.  The user drops the combo,
> selects the order, and I use FindFirst and Bookmark to position the
> recordset at the selected record.
>
> After a sales order record is deleted I need to requery this combo box so
> that the deleted record doesn't show in the combo box as #Deleted.
>
> I tried moving the requery to a different place in the code - no luck.
> Tried deleted and recreating the combo box - no luck.
>
> Anybody got any ideas for a workaround?
>
> Rocky