add record

[osupratt via AccessMonster.com]

I have a Field Ticket form that we enter job information into. In this main
form I have a sub-form that we enter the employees who worked on the job and
their hours and pay information. Not all jobs, but some Field Ticket jobs are
'hazardous' and the employees will get 'hazard pay' (50 dollars flat rate).

I would like to have a check box on the main Field Ticket form labeled
'Hazard Pay'. If checked, I would like to have a record added for each
employee in the pay Sub-Form that gives all the same information with the
Hours of 50 and the pay rate of 1 (this is how we calculate) and the pay
category ='HAZ'. Other fields include Date, EmployeeNumber, EmployeeName, etc.
but these values would be the same as what the clerk had entered previous to
checking the check box.

I don't know how to add records other than manually. Could anyone please
point me in the right direction? I would appreciate any help. Thanks.

 

[Tom van Stiphout]

On Wed, 31 Mar 2010 16:37:59 GMT, "osupratt via AccessMonster.com"

I am not sure I follow you entirely, but generally speaking records
are added using an Append query. Look it up in the help file.
Then once records are added to the underlying table, you may need to
requery your (sub-)form to see them. Check out Requery in the help
file.

-Tom.
Microsoft Access MVP