Adding Multiple Records by clicking a button

[amrja]

First of all let me start off by saying hi to everyone, I am new to this forum and I hope you guys can help me out.

I am working on a database for school work, and I need to be able to click on a button that will start a macro which will allow me to add about 9 records. One of the fields will have fixed information which will not change, while I should be able to select what information will be entered into one of the other fields (the information will be the same for all of new records). The rest of the fields will remain blank. Any suggestions?

Thanks,
Amr

 

[yellow]

Hello. You're going to have to code this rather than do it in a macro.

Basically, I understand what you need, you want to design a form. With a button on it. On the click event of this button add your 1 new fixed record to the table/s. Then perhaps ask how many other records are to be fixed, as you sound unsure about how many there will be in total. Then show a form asking for the relevant details. Save this data away in your table/s 8 time or howver many times you need to.

I'm sure there are lots of examples in this forum about how to add records through code.