Auto Fill based on last record entry

[L0b0]

How might I go about setting up a form to auto-fill any information that was entered in the last record, based on a lookup field? I dont want to change the original record, I want it to just populate the field that have been entered already for a new entry. This way the table will track updates and changes.

Hope this makes sense :banghead:

 

[pbaldy]

In the same session:

http://theaccessweb.com/forms/frm0012.htm

Otherwise you're probably looking at a recordset.

 

[L0b0]

In the same session:

http://theaccessweb.com/forms/frm0012.htm

Otherwise you're probably looking at a recordset.

This looks like what i'm looking for! How do I set this up?

 

[pbaldy]

I'd put it in the after update event of the control you want carried forward. If needed:

http://www.baldyweb.com/FirstVBA.htm

 

[L0b0]

Ah yes, I would like to use it on the onload. But what values am I exactly changing in the code to match mine?

 

[pbaldy]

Replace "Control" with the name of your control (textbox, etc).

me!Control.DefaultValue = cQuote & me!Control.Value & cQuote

 

[L0b0]

I thought so but it doesnt seem to be doing anything for me.

 

[pbaldy]

Can you attach the db here, with instructions on how to replicate the problem?

 

[L0b0]

I was testing it with the form labeled TESTupdates and for the moment the Order Amount field. It doesn't seem to work for me.

 

[pbaldy]

Database password?

 

[L0b0]

oh shoot my bad I thought I decrypted it.

View attachment OrdersWork - Copy.accdb

 

[pbaldy]

Seems to be working. I entered a record with 456 as the order amount, and when I went to a new record it had that as the default value.

 

[L0b0]

http://allenbrowne.com/ser-24.html this actually seems to work very well

 

[L0b0]

That's weird, I don't know why it isn't showing for me. This module works really well though. Thank you for your help!

 

[pbaldy]

Glad you have it working. Note that Allen's site points to the same link I gave you for "The first is best suited to setting a particular field"