Hello,
I have a Form that collects information for table tblRC. Table tblRC has a primary key RC_ID.
Sometimes, a record in tblRC should have a corresponding record in tblBC. In this case, the data enterer should click a button, which would create a new record in tblBC with primary key ID_Match (number field) equal to RC_ID (auto number field).
I have tried many iterations, but I am having trouble with syntax errors in the following statement. I have tried docmd.runSQL, brackets, single quotes, double quotes, etc, but can't seem to get this statement to work correctly. I am experienced with Excel VBA, but new to Access VBA. Any help would be appreciated! Thank you!
CurrentDb.Execute "INSERT INTO tblBC ([ID_Match]) VALUES (me.RC_ID)"