1,000,000 Monopoly dollars to whoever solves this!

[RamiMohaisen]

I have one table with three fields:

PR Number	Line Number	Order Number

I have a form with two text box's and one command button: txtPRNumber, txtLineNumber and cmdAdd.

Lets say i enter "Test PR", "7" and click the magic button. I am saying I have a PR with 7 line items. I need my table to auto populate with records. I will need 7 records in this example as shown below:

PR Number	Line Number	Order Number
Test PR	1
Test PR	2
Test PR	3
Test PR	4
Test PR	5
Test PR	6
Test PR	7

I need this so I dont make errors retyping the PR number and so I dont skip a line number or repeat one. Also saves alot of time considering some of these have 100 line items.

So really I need it to create a record in my table with PR Number the value I enter in the Text box on the form and copy this number to each record while autoincrementing the Line number.

[Bob Fitz]

I think that you've already asked and been given an answer:https://www.accessforums.net/showthr...320#post120320