How can I link tow tables without using a subform?
I have a data entry form for the main table.
On it, I have a combobox with several choices. If the user selects a specific choice, another Form will open, with a seperate table as the recordsource. Here the user enters that table's information, and then it closes.
What I want, is for the two tables to be linked, like I set up in my relationships (One to Many). However, I cannot seem to find a way to link them using the Forms. It always says it cannot find a related record. I have tried to use VBA, saying me.thisfield = the_other_form.that field, when the second form closes, but that doesn't work. I have tried re-setting the recordsource to the main data entry form to include both table's but that doesn't work.
It it possible to use Data Entry and link two table's data without using a SubForm?