I need to create an add record button on a form that pulls in data for 3 fields from a table (tbl A) into another table (tbl B), where all other fields in tbl B stay blank. The intent is the user needs to be able to add a new record while inside a form, and then the form can scroll to the next record for additional data entry.
Fields tbl A
LOG #
Date
Posted By
Fields tbl B
LOG #
Record #
Date
Posted By
Data Field 1
etc
I currently am using an append table query that is executed through a macro by clicking a button. It creates a new entry in tbl B that has the same LOG #, as the record open in the form, but with a unique Record # (an autonumber field).
When I try to add an additional record I now get a squaring effect. Because there are two records with the same LOG # (as necessity) when executing the button again it creates 2 additional records, then 4, 8, 16, 32 etc.
Any help on how to have a button create one new row in a table and assigned specific data from tbl a into 3 fields, and leave the rest blank would be great. I assume there must be some VBA I could use in execute procedure for the button.
Thanks - Kevin