D
Dala Dahlgren
I am trying to learn a little Access and I have created a small database to
play around with.
One of the tables in the database contains every sale made by a company. For
every sale I store information about customer, price of the sale, a field
inidcating wether the sale has been paid, etc, etc.
I then create a query which selects all the orders that have not been paid.
The records from the query are displayed in a form.
In the form I have a "check box" where I can mark the sale as paid. But when
I have marked the sale as paid I need to "refresh" the form so that the
upsated record disappears. I guess I will have to run the query again, but
how can I do this without closing and reopening the form? I want to attach
an "event procedure" to the check-box which updates the query when the box
is checked, but I am not sure what this "event-procedure" should look
like...
play around with.
One of the tables in the database contains every sale made by a company. For
every sale I store information about customer, price of the sale, a field
inidcating wether the sale has been paid, etc, etc.
I then create a query which selects all the orders that have not been paid.
The records from the query are displayed in a form.
In the form I have a "check box" where I can mark the sale as paid. But when
I have marked the sale as paid I need to "refresh" the form so that the
upsated record disappears. I guess I will have to run the query again, but
how can I do this without closing and reopening the form? I want to attach
an "event procedure" to the check-box which updates the query when the box
is checked, but I am not sure what this "event-procedure" should look
like...