repeat field value from previous row

Question

What is the best method to use to repeat a value in the same field, a number of times then change the value and have the new value repeat?

We make entries that come from a container list, where the container name stays the same until we move to the next container. can the container name be repeated, without any action by the person entering the data?

Answer 1

You might like to take a look at Defaults.zip in my public databases folder at:

https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

Note that if you are using an earlier version of Access you might find that the colour of some form objects such as buttons shows incorrectly and you will need to  amend the form design accordingly.  

If you have difficulty opening the link, copy the link (NB, not the link location) and paste it into your browser's address bar.

This little demo file illustrates, amongst other things, how to carry values forward to the next record, either in the current session of the form only, or for subsequent sessions of the form also.

Answer 2

I'm still working at translating the code to my database (not easy)

thank you for asking

Leon

Answer 3

Hi Leon,

You are welcome to post back if you have any updates.

Thanks,

Qing

Answer 4

Thank you for your quick reply, I will be looking over your table Sunday, and let you know how it goes.

Leon Kaliski

New York, New York