I have a tableconsist ItemType and ItemID
I want to create a form (EntryForm -> EntryTable) - combo box (ItemType) selection
Another input in the form refer the ItemType - but input from ItemID and insert into the table
can anyone assist me
tqvm
I have a tableconsist ItemType and ItemID
I want to create a form (EntryForm -> EntryTable) - combo box (ItemType) selection
Another input in the form refer the ItemType - but input from ItemID and insert into the table
can anyone assist me
tqvm
Create a select query.
In the Row Source property (Data Tab) of the combo box:
Change "ItemTableName" to your table name.Code:SELECT ItemID, ItemType FROM ItemTableName ORDER BY ItemType
On the Format Tab, set
Column Count = 2
Column Width = 0