Hello,
I've a form and its control source is Table1. On the same form, there is a cbo and text box which I wish to have control source from other table i.e. Table 2. I also want to add that there is also a subform on the form with control source SubTable. All the three tables i.e. Table 1, Table 2 and SubTable have relationship so that RecID in Table 1 is FK in other two tables.
I have tried using Select query (in which Table 1 and Table 2 are used) few week ago as control source of the main form but it gave me error something like RecID does not exist. Then I used unbound fields on the main form and used INSERT query to insert values in Table 2 but now I'm again having issues with this method so now I am trying to figure out if I could use some code to set control source of few fields on my form to other table i.e. Table 2.
Best Regards
I've a form and its control source is Table1. On the same form, there is a cbo and text box which I wish to have control source from other table i.e. Table 2. I also want to add that there is also a subform on the form with control source SubTable. All the three tables i.e. Table 1, Table 2 and SubTable have relationship so that RecID in Table 1 is FK in other two tables.
I have tried using Select query (in which Table 1 and Table 2 are used) few week ago as control source of the main form but it gave me error something like RecID does not exist. Then I used unbound fields on the main form and used INSERT query to insert values in Table 2 but now I'm again having issues with this method so now I am trying to figure out if I could use some code to set control source of few fields on my form to other table i.e. Table 2.
Best Regards