Auto fill from previous cell

[sajlen1414]

Simply.
It looks like this:



Short no and Example are static auto fill (10 and 1503 are the most common so they auto fill)
But Long no cant be auto filled like that. As you can see Long no has to be somethimes copied and pasted which is problematic.
My idea is for New record to auto fill from last known record. In this example autofill Long no from record 6 with 986656551.
Like this:

Obviously if there were other no in record 6 auto fill should look differently.
I hope I made myself clear.

[apr pillai]

Take a look at this: Duplicating fields with Conditional Formatting.

[June7]

One method is to set the DefaultValue property of LongNo. In LongNo textbox BeforeUpdate event VBA procedure:

Me.LongNo.DefaultValue = Me.LongNo

However, setting the value in new record when the form first opens is a different issue and more complicated. Do you need this behavior?


I am curious, never seen (Newy) in new record row, always (New). Do you know why it shows a 'y'?


Advise no spaces or special characters/punctuation (underscore is exception) in names. Better would be LongNo or Long_No.

[sajlen1414]

Unfortunately I am not so advanced in acces (wich is why I asked for help in the first place) and therefore even though your answet gave me 2 hours in front of my PC trying to do something I did nothing. If you could say what to do like to a 10Yo I would be glad.

P.S.
It's not Newy
It's Nowy
I am from poland and Nowy(PL) = New(ENG)

[June7]

Try:

1. form in design view

2. select the textbox for the value you want to repeat

3. on the Properties dialog Event tab, BeforeUpdate event, select [Event Procedure]

4. click the ellipses (...), this will open the VBA editor in the procedure

5. type code: Me[.Long No].DefaultValue = Me.[Long No]

6. save form