Extract data from a record to input into another record from same table

[John_In_Northern_California via AccessMonster.com]

I'm the registrar for a Little League and I track all of the information
about players, coaches, sponsors, etc. When I come across an instance where
siblings are playing, I would like to create a new record and "autofill" the
input form with some of information (address, phone email, etc.) from a
sibling's record by using a single "Add Sibling" button. Thanks for any help -
John

 

[Boyd Trimmell aka HiTechCoach via AccessMonster.co]

Sounds like you may want to update your table structures to be better
normalized to handle your data so that you eliminate duplicate data.

I would probably create some type of "household" or "family" record the links
the siblings and holds the shared address, phone email, etc

 

[Linq Adams via AccessMonster.com]

I would agree with Boyd if this were something more complicated than rosters
for a Little League! But try this:

Private Sub CopyPartialRecordButton_Click()

'Copy fields to variables
MyFirstField = Me.FirstField
MySecondField = Me.SecondField
MyThirdField = Me.ThirdField

'Go to a new record
DoCmd.GoToRecord , , acNewRec

'Reverse the process and plug old values into new record
Me.FirstField = MyFirstField
Me.SecondField = MySecondField
Me.ThirdField = MyThirdField

End Sub