Auto Fill

[mugman17]

I have a form where users can enter a price for a specific date. Sometimes this price doesn't change for months, so instead of entering the same price 60 times for 2 months. I would like another form that gives you a start date and an end date to enter and the price, and it will automatically fill the table with this price between those two dates.

 

[mugman17]

I wanted to keep the results in the same table as the other form, which just has:

PriceID
Price
PriceDate

Also, if I did it the way you suggested, how do I show a query between the two dates where the price shows up daily:

example:

1/11/2003 3.45
1/12/2003 3.45
1/13/2003 3.45.....