Temporarily freezing Form.

[hooi]

Sometime ago I used a Access Macro feature that allowed me to keep the current form to remain the same while behind the scence, the form is actually closed and reopen. The reason the form has to be closed and reopened (using Macro again) was because I've provided a button in the form which allows user to create a new record copied from another record from the same table. However if the form is not closed and reopened, the new record is not visible from the current form even when I scroll through the entire recordset.

I'm trying to find that Macro which allows me to temporarily freeze the form display so that it doesn't appear to flash as a result of closing and reopening of the form.

Could anyone point me to the right macro please. Thanks...

 

[Rich]

Requery the form

 

[hooi]

Thanks...

 

[hooi]

I'm trying to move to the last record (to the newly created record) after requery. But it doesn't work with GoToRecord -> Last when using macro. What should i do? Thanks...

 

[mission2java_78]

I'm trying to move to the last record (to the newly created record) after requery. But it doesn't work with GoToRecord -> Last when using macro. What should i do? Thanks...

Set the focus to the form and do a DoCmd.Goto or something like that...or DoCmd.GotoRecord and there is an argument to move to the last record, i.e : acLast.

Jon

 

[hooi]

Thank you. Here is what has actually been done using Macro for it to work:

Requery
SelectObject (form)
GoToRecord -> Last.

fyi please.

 

[hooi]

My apologies, the correct one is as shown below:

Requery
SelectObject (form)
ShowAllRecords
GoToRecord -> Last.