Creating Form with Multiple Records all with a common date

[kenkard]

I'm brand new to Access and am trying to creat a simple form. It's based on a table called "purchases" which contains a date, item #, qty & price and you can see that I created a real basic one in the attached file. Trying to make something where we only need to enter the date once but then have an unlimited number of records to add as some days there could be 2 purchases and sometimes 50. I'd envision the titles going accroos the top and the records going down the side. Guess an old man needs to go back to school.Purchases (2).zip

[Missinglinq]

You can use the AfterUpdate event of the Control holding your data to set the DefaultValue for the Field. From that time forward, until you either manually change the data or close your form, the data will be entered automatically in each New Record.

Private Sub Purchase_date_AfterUpdate()
 Me.Purchase_date.DefaultValue = """" & Me.Purchase_date. Value & """"
End Sub

which is valid for Text, Number and Date Datatypes. Never tried it on a Yes/No Field!

Linq ;0)>