Refresh a form

[PJ]

I have two subforms linked to a main form. I have a button that has a append
and delete query attached to it. It moves data to another table/form and
then deletes data from another form. After that happens the forms do not
refresh unless I get out of the main form. Where should I put the refresh
command.

Thanks in advance.

 

[Keith Wilby]

I have two subforms linked to a main form. I have a button that has a
append
and delete query attached to it. It moves data to another table/form and
then deletes data from another form.

Yuk!

Stop moving data from table to table! Have one table with a Boolean field
to signify its position/significance/importance. So for example, if you're
moving data to a "Deleted" table, instead have a "deleted" flag in one table
and set it as appropriate. All you need do then is to query as appropriate
for your forms.

Keith.
www.keithwilby.co.uk

 

[PJ]

Keith,

I have never done a "delete" Flag in a table. Please advise me of the
process.

Thanks

 

[Keith Wilby]

Keith,

I have never done a "delete" Flag in a table. Please advise me of the
process.

I have a table with records that I might want to flag as having been deleted
without physically removing them from the table. I have a "Deleted" field
of data type Boolean (yes/no) which I use code to populate if a user presses
a "delete this record" command button on my form. I can then use a query to
filter on the "Deleted" field so that the form shows only those records not
flagged as deleted. I could also use an option group on my form with
"Current" and "Deleted" options to switch between to two.

HTH - Keith.
www.keithwilby.co.uk