Thanks for your advice Craig, but I don't see how that would work?
Creating the recordset for Table A will of course be empty because there is nothing to filter it by until the form is posted.
So I don't see how that can stop the form from inserting if you have to insert it in order for it to get the form value?