Refreshing a form + its contents

[Lockstock2SB]

Hi all

I am currently trying to make a database which is causing me grief in the process !

I have a form based on a query, which only displays records that have their got check box unchecked. What i want to do is create a button on the form that saves the current record, re runs the query so that any records that have been checked - disappear, and refreshes the navigation toolbar at the bottom of the form - without having to come out and go back into the form.

Could anyone show me how to do this please !?

Thanks,

Steve

 

[LittleSmudge]

In the button's OnClick event do a
REQUERY the Form


If you like you could do away with the button altogether by doing the requery in response to the tick box's OnChange event. As soon as you click the tick box the requery makes the record disappear!


G LS

 

[LittleSmudge]

Okay - so the tick box doesn't have an OnChange event. Oops !

Try OnLostFocus which will make the record vanish as you tab off the tick box to another control

Or AfterUpdate which will make the record vanish as you move focus to a new record.
( This option might have a more comfortable feel about it as far as the end user is concerned. )


G LS