Update table through form

[Ice Rhino]

I am almost embarressed to ask this. I feel it is such a simple thing to do, and yet I can't work it out.

I have a tbl that I want to be able to edit the contents of a record through a form. I want to be able to select the records unique Identifier from a combo list of asset numbers.

So basically the user will click on the Asset number which will then populate all of the other fields I allow them to edit. They can then make the changes and either;

a. Click on another asset number and continue editing records
b. Shut down the form

Anybody?

 

[Ice Rhino]

Excellent Pat, exactly what I wanted.

Many Many Thanks

 

[Ice Rhino]

How would I get it so that as soon as you open the form you are looking at a blank record rather than the first record in the tbl?

The Combo box works great but it would be nice to be presented with a clear screen on form load

All the Best

 

[Ice Rhino]

Thanks Pat. I did the onload event for the form and did the

DoCmd.GoToRecord , , acNewRec

All sorted thanks very much