Duplicate field(s) from previous record?

[Panchdara]

I have a fishing entries database. Members submit catches and an Angler may have multiple entries on same date. How to populate the [Angler] and [DateCaught] fields based on the just inserted record? ie, I'm trying to autofill the fields based on the previous record that was inserted? AND, I need to make sure that if entering the very first record in that session that these fields are filled with blank data.

Makes sense.

Oh.. just joined this forum. I hope to learn and participate in a very constructive way.

Hugh

 

[Remou]

Use the AfterUpdate event of the relevant controls to set the default value property:

[tt]Me!SomeControl.DefaultValue = "=" & Chr(34) & Me!SomeControl.Value & Chr(34)[/tt]

 

[Remou]

Do both you and mcongdon go to the same school?

 

[Panchdara]

Works like a champ.... I saw mcongdons' question and I was shocked and amused! Great minds...!

Ciao

 

[Remou]

Great! Welcome to the forums, wander around, learn, enjoy, read the FAQs

 

[Panchdara]

And I will ALWAYS read the FAQs from now on...! As I just did, and I really, really love this solution:

http://www.tek-tips.com/faqs.cfm?fid=4852

Me bad... me be gud from now on.!

Bestest