Problems with Form filtering

D

dp

Hi everyone:

I am having a problem with MS Access bugginess, which I have encountered
before.
I have a form with a filter for the record ID.
This form allows the user to view the current record, and then I have
programming to send fields from the form record to MS Outlook using
Me.fieldname, etc.

The problem my clients are having is, intermittantly, the form will filter
the correct record, but the outlook record will be from the wrong record.
This will happen maybe 1/30 times.

I am using the ME syntax and this should suffice. I mean do I have to
create a whole ado recordset to ensure Access behaves itself....

Has anybody else had this problem with Access incorrectly filtering records?

thanks
 
Top