Default values in fields

[garybh]

Hi, I am a newbie in MS Access. I am trying to write a simple database to record engineering drawings received. I would like to retain an entry into a field from a previous entry, but if it is slightly different allow the value to be overwritten.

For example:

If I receive a drawing from a particular person, (say) Osborne, then that is entered into the senders field. The next drawing I receive also from Osborne, wil already have Osborne in the entry field from the previous entry so I will not have to retype it. If a drawing is then received from someone else then Osborne is overtyped with the name of the new sender.

Anyone help a newbie with this please? Thanks

 

[SamDeMan]

if you have an autonumber set up in the table you can do the following:

you can then set up a query for max(ID) and attach that value to senders field.

sam