Add fields based on drop down box

[rmoore]

How do I make a drop down box that when the value is selected it will create that many more text fields in the same table and form. The new text fields need to be populated with dates based on a start date with a interval determined in another field.

Example:
Drop down box selected 6


6 date fields named "PaymentDate1, PaymentDate2, PaymentDate3, Etc...." inserted in table or form
Select date in "PaymentDate1"
PaymentDate2 thru PaymentDate6 is autofill based on a interval field.

[CJ_London]

tables are tall and thin, not short and wide like excel

so I suspect you need code to insert say 6 new records, not create 6 new fields

something like this in the dropdown box afterupdate event

dim i as integer
dim sqlstr as string

for i=1 to combo
    sqlstr="INSERT INTO myTable (PaymentDate) VALUES(#" & dateadd("d",me.interval*i,date()) & "#)"
    currentdb.execute sqlstr

next i

[rmoore]

I dont want new records. If I select (?) in the combo box, I need that many fields added to the form.

When I use your code I get
Compile Error:
Method or data member not found

[orange]

You have suggested multiple repetitive fields fld1,fld2, fld3... which is a red flag indicating you have a table/database design issue.
These additional "fields" should be records in a related table. In your case it could be Customer or Invoice or other indicating a repayment schedule.. Need more details on your set up, but you definitely would not be following standard database practices with your current approach.
Good luck.

[rmoore]

That makes sense... i will make a payment schedule table. But i still will have a problem with the dates.

How many date fields needed is determined by number of payments, which changes per record

[CJ_London]

on the basis you are talking about financial loans, very simplistically you would have two tables - name and amount of loan in one and a related table for repayments something like this

LoanID...LoanName...LoanAmount...LoanDate...NumRep ayments...Frequency
1...........LoanX.........100...............1/1/2020....4........................Monthly
2...........LoanY..........300...............1/1/2020....10......................Weekly



RepaymentID...LoanID..RepaymentDate...RepaymentAmo unt
1....................1..........1/2/2020............25
2....................1..........1/3/2020............25
3....................1..........1/4/2020............25
4....................1..........1/5/2020............25
5....................2..........8/1/2020............30
6....................2..........15/1/2020..........30
7....................2...........22/1/2020.........30
etc

note that technically you do not need the repayment schedule table since it can be calculated from the loan table as and when required - but presumably you would need an actual repayment table to record the amount and date of a repayment