Refreshing a form

[chancer1967]

Question 1:
I have a form/subform that lists invoices owed by a customer

The user can click on an invoice and click a 'write-off' button that opens up a new form populated with the invoice data. They select a reason code then press submit, which closes the write-off form (using a macro).

Having done that, the invoice would no longer show as outstanding, but the original form is still showing it, as it has not refreshed.

What I want is for the original subform to refresh when submit is pressed on the write-off form.


Currently I have a refresh button on the form (firing a macro), so I have to instruct the user to hit refresh after making a write-off.

It would be nice to have that happen automatically - I tried copying the requery command that I have in the refresh macro in to the closeform macro, but it errored.

Is there a way of doing this in the closeform macro, or would it need VBA?



Question 2:
I am using conditional formatting to change the font color when the user clicks on an invoice in the subform, but it only works on the specific field clicked.

It there a way to highlight the entire record when any field within it is clicked?



Thanks in advance!

 

[Rich]

Scrap the Macro, it's just
DoCmd.RunCommand acCmd SaveRecord
Forms!YourFormName.Requery
in the unload event of the form

 

[chancer1967]

Now THAT

worked a treat!

 

[chancer1967]

re Question 2 - I tracked down the answer and its pretty ugly