Data Carry-Over on New Records (1 Viewer)

C

cokeblue8

Registered User.

Local time

Yesterday, 18:28

Joined

Aug 28, 2007

Messages

38

• Sep 7, 2007

• #1

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

AWF VIP

Local time

Today, 02:28

Joined

Jul 22, 2004

Messages

1,649

• Sep 7, 2007

• #2

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

 

C

cokeblue8

Registered User.

Local time

Yesterday, 18:28

Joined

Aug 28, 2007

Messages

38

• Sep 7, 2007

• #3

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

Access amateur

Local time

Today, 11:28

Joined

Jun 1, 2003

Messages

995

• Sep 10, 2007

• #4

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.

 

Attachments

• PrevRecord.zip

  15.6 KB · Views: 167

C

cokeblue8

Registered User.

Local time

Yesterday, 18:28

Joined

Aug 28, 2007

Messages

38

• Sep 10, 2007

• #5

Hi John

Thank you so very much