Editing a record

[grenee]

Good Day all,

Can anyone send me a link to information on how to code a vba module that would open a table find a record and edit that record?

The code is to be trigerred by an event call from a control on a form.

Thanks

 

[Minty]

You should be using a form to do this, not opening the table directly.

The search function should display the record on the form, and then the user can edit the only the fields you want them to on the form.

The Northwind Sample database included with Access has examples of this.