the code which used in form2 for show the data in combo is
SELECT [tblPersons].[PersonID], [tblPersons].[PersonName] FROM tblPersons;
which mean showing only the data from another table
but I want show the data from to field to add it in another field , is it clear ?
remember that my question is
How can I load combo in form of table A from table B
more details :
table A has a form A . I make a combo in form A to add data in table A ,
I want to fill the menu of combo with data from table B