After Pushing Dup Rec button , need to requery some how to see new Rec

[aunixguru]

(Access 2k)

I have a button on a subform that dupes the current record to a new customer by use of a append query.

I cannot figure out how to requery or refresh in code to have the record show up.

The subform is linked to the main form. If I exit the screen and come back in the record will be there.

Any ideas on how to force the refresh so that I don't have to close the screen?

Main form = Main Menu
Subform = Quotes.

Thanks.

 

[Aivars]

Hi!

You may requery all objects what datasource or rowsource contain fields of updated tables.

private sub cmdUpdateButton_Click()
........
........
Codes for update table

me.requery
forms("Main Menu&quot.requery

end sub

Aivars