I want to make a combo box in the Main Form which will list and select the following 2 fields in a 2-column list. First column will have the ID field from the second table which is in the subform and in the second column there will be the field named Code from the first table which is in the main form. Ofcourse by typing in the Combo box the [ID] number of the 2nd table should put in the second column the [code] field from the record that is related with the ID in first column.
What After Update event should I type to do that?
For a single form i had the following.
[code]SELECT [Table1].ID, [Table1].[code] FROM Table1 ORDER BY [Table1].
Expand|Select|Wrap|Line Numbers
- ;