Create multiple predefined records in 2nd table onClick based upon values in a 3rd table

[spikemannen]

Hi,



I have a bit of struggle figuring out how to (in an easy way) create multiple records in a 2nd table when user click on a button in a form with another recordsource.

Scenario:
User is in HOME form with recordscource = tblUser.
Upon selecting to enter a competition I want to create a number of predefined records for that user in another table (tblScorecard).
The predefined values for the records in tblScorecard is userID (same for every created record) and matchID which comes from tblMatches where gameTypeID = 1.

So let's say that tblMatches has 10 records with gameTypeID = 1, then I would want ten records created in tblScorecard with the same userID, one record per each unique matchID.

Much appreciate any and all suggestions on how to approach this.
Thanks

[Welshgasman]

Use an append query.

[spikemannen]

Yes, but how do I define in that query that I want a different matchID for each of the ten records? (and not knowing it is ten)

[Welshgasman]

I would be building the query in vba and a loop for as many records as required.
You would populate the fields with your userid and whatever else you need in that record.
Google 'access append query vba'

[moke123]

Might be easier if you upload a sample with just enough info to show your issue.