Need Help

[Ron]

I have several forms that i am working with. The main form is called Audit
scedule. There is a subform that updates when I enter new data. There is
another form called Audit results. I want to be able close out the schedule
when I enter information on the audit results form. I want the line in the
subform to be removed from the schedule. Does any one know how this can be
done?

 

[Jeanette Cunningham]

If the subform is open when you want to remove the record from its record
source, you could have a public function on that subform that deletes the
speciified record and then requeries the subform.
You would need to pass the ID of the record to delete when you call that
public function (from the audit results form) to delete that specific
record.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[silvio pizzorni]

I have several forms that i am working with. The main form is called Audit
scedule. There is a subform that updates when I enter new data. There is
another form called Audit results. I want to be able close out the
schedule
when I enter information on the audit results form. I want the line in the
subform to be removed from the schedule. Does any one know how this can be
done?