Click a button > populate rows

[the boy holty]

I've been asked to make an amendment to an existing access database. I'm fairly new to Access (at least the complicated stuff), but I have quite a bit of SQL Server experience and I've dabbled in c# programming so hopefully that'll help.

So here goes.

My Access database has a form that needs to be filled out by the system user (not me). Problem is its quite a laborious process and they want to make it easier by having the rows pre-populated to a large degree and they'll just fill in the key fields rather than entering data in the whole form. It makes sense as there's a lot of repeated tasks in filing the form.

What I think I need is a button which when pressed will enter ten new rows into the database table, using the date and shift code from a previous form and with certain values hardcoded and set as standard.

If this was in SQL Server and asp.net or c# it would be a piece of cake. I'd just write a quick stored proc to run an INSERT statement and tie it to the button's click event. I'm guessing (and hoping) that the process would be similar in Access but I've not done anything as complicated as this in Access before.

So I guess what I'm asking is, is it possible to insert multiple rows to a table on the click of a button and in doing so also populate certain fields where the data comes from values entered into a previous form?

I'd be very grateful for any advice you can give. Thanks in advance.

 

[the boy holty]

OK, Update time.

I have written a query that inserts ten rows on the click of a button. I'm happy with that, but it has revealed one or two other minor issues.

There is a form on which the button which runs the query resides, but I also want it to close the form in the same click event.

The second thing is that a previous form needs to be refreshed on the click of the same button.

Is it possible to tie three events one one button, and how do I do these things mentinoed above:
a) close the form
b) refresh a different form

Thanks again.