I need help with query criteria

[Guest]

Hello Access gurus,

I have a form that contains a subform. This subform has continuous records
and each record has a button attached.

The purpose of the button is to move the current record to a second table,
delete the record from the first table and then open the record in the
investigation form (manager's requirement so don't ask!)

At the moment the two queries (append and delete) have a "Dmin" criteria so
it will only append the record with the lowest QLN number. I have realised
the error and I want to change the criteria in both queries so the button
will append and delete the record for whichever button I click on in the form.

thanks

 

[Keith Wilby]

Hello Access gurus,

I have a form that contains a subform. This subform has continuous records
and each record has a button attached.

The purpose of the button is to move the current record to a second table,
delete the record from the first table and then open the record in the
investigation form (manager's requirement so don't ask!)

At the moment the two queries (append and delete) have a "Dmin" criteria
so
it will only append the record with the lowest QLN number. I have realised
the error and I want to change the criteria in both queries so the button
will append and delete the record for whichever button I click on in the
form.

thanks

I would suggest that your method of satisfying the requirement needs a
review. Why move the record at all? I'm assuming that the receiving table
has the same spec as the donor, so why not just have a "moved" flag against
each record? You can then filter your subform's recordset on it. Moving
records around will only serve to bloat your data file.

Just my 2p worth.

Keith.
www.keithwilby.com

 

[Guest]

The way I had before it worked okay but you're right.

thanks