Sticky fields

Question

Looking to make a field on a form Sticky.  I want to hold the value of field 1 while changing the value of field 2 for each record entered.

So after im done the table should look like this...

field 1             field 2

Box00001      99999

Box00001      88888

Answer 1

I'll give it a try.  Thanks

Answer 2

Maybe add a text box in form header to enter value you want to use in field1.  Set default for field1 textbox to that text box in the header.

You will need to enter the value in the header text box and the first new record field1.

---

Build a little, test a little.

Answer 3

Looking to make a field on a form Sticky.  I want to hold the value of field 1 while changing the value of field 2 for each record entered.

So after im done the table should look like this...

field 1             field 2

Box00001      99999

Box00001      88888

 

In the AfterUpdate of the form, set the DefaultValue property of field 2 to the string representation of field 1.  For example:

'------ start of example code ------

Private Sub Form_AfterUpdate()

    Me.Field2.DefaultValue = """" & Me.Field1 & """"

End Sub

'------ end of example code ------

---

Dirk Goldgar, MS Access MVP

Access tips: www.datagnostics.com/tips.html