Populate a record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to input records where normally the data fields is the same for each
record except for a few fields.
I would like to populate the info from the current record to the next record
while inputting.
Data bought to the next record: Box#,Dept#,Retent,etc.
Thanks Terry
 
I need to input records where normally the data fields is the same for each
record except for a few fields.
I would like to populate the info from the current record to the next record
while inputting.
Data bought to the next record: Box#,Dept#,Retent,etc.
Thanks Terry
Click to expand...

You can set each control's DefaultValue property in the control's
AfterUpdate event:

Private Sub txtBoxNo_AfterUpdate()
Me!txtBoxNo.DefaultValue = Chr(34) & Me!txtBoxNo & Chr(34)
End Sub

Note that # is not recommended as a character in field or control
names (it's a date delimiter and Access can get confused).

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Thanks John it works great - Terry

John Vinson said:
You can set each control's DefaultValue property in the control's
AfterUpdate event:

Private Sub txtBoxNo_AfterUpdate()
Me!txtBoxNo.DefaultValue = Chr(34) & Me!txtBoxNo & Chr(34)
End Sub

Note that # is not recommended as a character in field or control
names (it's a date delimiter and Access can get confused).

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...
 
Back
Top