Find

[SteveE]

Not sure if this is possible or how but:
I want to update only a couple of fields on a job form date and time etc. and would like to be able to 1/ locate the full record then update only the selected fields. My thoughts are for an entry field which on exit? would do a find record according to the record number entered, presently I just use the access find but I would like to make this quicker by not going through the number of selection clicks each time.

any suggestions please
thanks

 

[Mile-O]

What's wrong with an UPDATE Query?

 

[SteveE]

I know i could use an update but that would be just a quick as the way we currently do it,
If I could just explain, each record is a delivery record, the final fields to complete the record are delivery date, time and name. Presently the delivery record is located by a normal an access find on the record number and this brings all the rest of the data into view on the form so all details can be checked at the same time, the additional info is them added, job finished. There are many records which are entered over the course of the day so I was just trying to simplify things by speeding up the find process, cutting out the dialouge boxes etc.