Solved Fill empty fields in column with above value access (1 Viewer)

[gogea]

Hello Experts,

I want to use MS Access for scanning labels, and in the process I want some checks to be done.
The reff field represents the part number on the master label (which is scanned one time per pallet) and the scan field contains the labels for each part number( so one pallet has one master label and contains 30 part numbers each one with own label).
Using calculated filed I was able to extract the information from the 2 fields which has to be the same (from reff to reff_1 and from scan to Field 2).
My purpose is to check that the dates in reff_1 and Field2 are the same ( to check that the part number from the master label correspond with the part number on each 30 "small" labels ).
But, as the master label is scan just once per pallet, I need that in field reff_1 the empty spaces between scanning 2 master labels to be filled with the above value( so in my example rows 181-184 should be filled in reff_1 field with 059 129 711 EB, rows 186-187 with 059 129 711 EC, etc...).
Upon the comparison, if the field are different an error message should be displayed,

Any help will be greatly appreciated!!

Thank you

id	reff	label	qty	reff_1	scan	Field1	Field2
180​	P059 129 711 EB	M344602146	Q30	059 129 711 EB	#059129711EB	059129711EB	059 129 711 EB
181​					#059129711EC	059129711EC	059 129 711 EC
182​					#059129711ED	059129711ED	059 129 711 ED
183​					#059129711EE	059129711EE	059 129 711 EE
184​					#059129711EF	059129711EF	059 129 711 EF
185​	P059 129 711 EC	M344602147	Q30	059 129 711 EC	#059129711EG	059129711EG	059 129 711 EG
186​					#059129711EH	059129711EH	059 129 711 EH
187​					#059129711EJ	059129711EJ	059 129 711 EJ
188​	P059 129 711 EF	M344602148	Q30	059 129 711 EF	#059129711ET	059129711ET	059 129 711 ET
189​					#059129711EW	059129711EW	059 129 711 EW

 

[isladogs]

If there are only a small number of empty fields to populate with the previous value, clicking ctrl + ' (apostrophe) will do exactly that.
If there are too many for that to be practical, there are various solutions. Start by looking in the similar threads at the bottom of the page or do a forum search as this question also came up recently

 

[MajP]

See me emulated Excel fill down code

Access Fill Down to Emulate Excel Fill Down

Recently there was a user trying to emulate the Excel fill down functionality based on imported data. I am re-posting this solution here since I could see some utility and this may be a common issue. The OP mentioned doing several web searches and not finding an easy solution. The solution...

www.access-programmers.co.uk

 

[isladogs]

Thanks @MajP. That was probably what I was thinking of when I said it came up recently.
Suggest we move your thread to the code repository. Let me know if you're happy with doing that.

 

[MajP]

That will be fine, please go ahead and move it.

 

[isladogs]

Done! Just the first post. The new link is https://www.access-programmers.co.u...-fill-down-to-emulate-excel-fill-down.311868/

 

[gogea]

That solve my problem.
Thank you all