Data Carry-Over on New Records

[cokeblue8]

Hi

Is there a way to carry over data input from the previous record into a new record?

I have a combo box which users input a line number. When a new record is added, I want that same number to appear by default into the line combo box (but is still able to be changed if needed)

Is there a way to do this?

 

[Dennisk]

you could try it like this

1)creating a form variable
2) in the on change event for the combo box set the variable to the value selected.
3) Use a new button and place a line of code to populate the combo box from the variable.

It may be possible to use the forms after update event instead. - experiment

 

[cokeblue8]

hey thanks for your reply

i'm a complete noob at vba, could you please provide me with an example of how i would code that?

 

[ansentry]

cokeblue8,
Have a look at my attached sample. This will copy over the name of the state each time that you click the command button.

 

[cokeblue8]

Hi John

Thank you so very much