Repeating same Data to the next/new Record

[djclntn]

I hope that there’s a simple way to achieve my objective. Say I have 4-fields in a query/form, 3-of the fields contains the same data from the previous Record pretty much contain for the follow 4 to 5 new Records. Is there or what is the code to have a field (or fields) be repeated from the previous Record? This is more dealing with Forms rather than queries. Sometimes I come here asking question & I feel as though I made sense, where many of you guys weren’t following me/understanding me. However, in this thread/question I may not be making sense & may need to elaborate some more.

Let me provide an example:


The 4-fields are,: 1) Zip Code, 2) PostOffice, 3) County, & 4) Map#
When inputting these 4-flds of data in a Form, the first 3-flds are the same, but every ZipCode/PostOffice might be on 3 to 5 Map Pages.

19001 -- Abington – Mnt – 3258
19001 -- Abington – Mnt – 3259
19001 -- Abington – Mnt – 3370
19001 -- Abington – Mnt -- 3371

[pbaldy]

Try this type of thing, but in the after update event of each control:

http://access.mvps.org/access/forms/frm0012.htm

There's also:

http://allenbrowne.com/ser-24.html

[djclntn]

Paul,

I tried:
Private Sub Co_AfterUpdate()
Const cQuote = """"
Me!Control.DefaultValue = cQuote & Me!Control.Value & cQuote
End Sub

Private Sub PostOffice_AfterUpdate()
Const cQuote = """"
Me!Control.DefaultValue = cQuote & Me!Control.Value & cQuote

Private Sub ZipCodes_AfterUpdate()
Const cQuote = """"
Me!Control.DefaultValue = cQuote & Me!Control.Value & cQuote
End Sub

It's not working

[pbaldy]

"Control" needs to be the name of the control (textbox or whatever). Try:

Private Sub Co_AfterUpdate()
   Const cQuote = """"
   Me!Co.DefaultValue = cQuote & Me!Co.Value & cQuote
End Sub

I personally would declare the constant once in a standard module rather than in each sub.

[djclntn]

Paul,

I figured it out. I needed to put the field's name in place of 'Control' for each field

Thanks!

[pbaldy]

You must have missed post 4? Glad you got it sorted out in any case.

[djclntn]

Hey Paul,

In a Form (in Datasheet View) how do I set a sort order? I want it to sort according to the ID (Autonumber), but I can't figure it out. It's probably very simple, i'm just missuing it

[djclntn]

Paul,

Nevermind, I think I got it. I sorted the desired field by clcking on top of the field's name (right side), chose 'sort/ascending, & made sure to save the Form. When I reopened the Form it seems to be sortedx as I set it.

[Missinglinq]

For future reference, in Form Design View you can go to Properties-Data and in the OrderBy Property enter the Field Name enclosed in Square Brackets: [ID]

Make sure that the 'Order By on Load' Property is set to Yes (which is the Default.)

Linq ;0)>