Prev: how to upload picture from desktop to face book
Next: how do i delete
From: Ron on 17 Apr 2010 18:41
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?
From: Jeanette Cunningham on 17 Apr 2010 19:53
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

"Ron" <Ron(a)discussions.microsoft.com> wrote in message
news:BA93E412-8148-40A2-834F-A374EF0B6E5C(a)microsoft.com...
>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?


From: silvio pizzorni on 18 Apr 2010 07:30

"Ron" <Ron(a)discussions.microsoft.com> ha scritto nel messaggio
news:BA93E412-8148-40A2-834F-A374EF0B6E5C(a)microsoft.com...
>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?

 | 
Pages: 1
Prev: how to upload picture from desktop to face book
Next: how do i delete