Help with Form which allow selection from one table and create transactions in anothe

[ravikiran]

Hi Gurus,

I am quite new to using Access forms though good with VBA. Probably my question is very simple though I having trouble to achieve it :banghead:

Requirement: My db has 2 tables. Employee table and Transactions table.
I need to read through the Employee table and loop through each SELECTED employee and add One Transaction for each of them.

e.g: If Emp A, C and E in tblEmp are selected, I need to add the following records to the tblTransactions:
1 A Salary 500
2 C Salary 1000
3 E Salary 500

Can I create a form where the SELECTION option is available and appends the data to the table? I am practicing to avoid VBA as much as possible.

File attached below:
Thanks for your help in advance.

Cheers.

 

[sneuberg]

I believe you could do what you want with an append query; however, I noticed that the Check19 checkbox in the frmSalarySelf is not bound to a table. If you don't bind this to a table, where it could store a value for each record, it will act like a single checkbox for all records. If this database isn't going to be split and shared you could probably just add a Yes/No field to the tblEmp for this.