To AutoFill or Not To AutoFill

[teh1]

This should be about as simple as it gets, yet I can't determine how to do it.

I have a table with form that I want to enter data. The fields in the table are: Invoice, InvoiceDate, & Amount. The Invoice and InvoiceDate will be the same for 50 or so entries. On a form, how can I just enter the Invoice and InvoiceDate one time and have it autopopulate itself for every Amount that is entered? Will some sort of Autofill do the trick or is there something easier?

I originally thought I could create a Main/Subform and have the Invoice and InvoiceDate on the Main Form with the Amount in the Subform but couldn't get it to work exactly like I wanted.

 

[teh1]

Pat,

You are correct, there is other info but I was trying to keep the example as simple as possible yet contain everything that I need done. I simply need to be able to enter data into ONE table using a form but having repeating values for two fields and allow me to enter data for a field that does not repeat. This is not a "true" invoice in the normal sense.

I'll take a look at the example that you mentioned to see if it has a method of doing just that.

Thanks

 

[teh1]

Thanks for the info. I have many tables in the database. Again, I was trying to keep the example simple since it didn't require details of other tables. I only needed to enter data in this table. The one-many relationship does not come into play with entering the data on this form.

Thanks to code from Jack Cowley that I found in another message, I got it to work exactly as I wanted.