Find row by ID using button

[Wolfenden]

Hi all
is there a simple way to put a button on a form, so I can enter the ID numberand the form will populate with the corresponding row to allow for editing. Ihave access 2007.

[ranman256]

have a form connect to a query for ALL records. The form is mult-record view
in the form HEADER, put the box to enter the ID, and a button
on the button on_click event

me.filter = "[id] = " &  txtBoxID
me.filteron = true

[Wolfenden]

works a treat thankyou