SOLVED: Create combo box in Form to look up values in a table
I am trying to create a combo box on the form that will allow me to make selections from the ExpenseCategory and ExpenseItem fields (see below), can you tell me the steps to take in order to do that?
I’ve been successful using the lookup wizard to create combo boxes from typing in the values that I want, but if I want to add values later on I have to redo the form and table. It seems more logical to set up the lookup column to look up values in a table, so I can add additional categories or items in the future without having to recreate any tables or forms. Can you give me guidance so I know how to do that?
These are my tables
TblExpenseCategory
ExpenseCategoryID
ExpenseCategory
TblExpenseItem
ExpenseItemID
ExpenseCategoryID
ExpenseItem
TblExpense
ExpenseID
ExpenseDate
Comments
TblExpenseDetail
ExpenseDetailID
ExpenseID
ExpenseItemID
Projected Cost
Actual Cost
I am trying to create a combo box on the form that will allow me to make selections from the ExpenseCategory and ExpenseItem fields (see below), can you tell me the steps to take in order to do that?
I’ve been successful using the lookup wizard to create combo boxes from typing in the values that I want, but if I want to add values later on I have to redo the form and table. It seems more logical to set up the lookup column to look up values in a table, so I can add additional categories or items in the future without having to recreate any tables or forms. Can you give me guidance so I know how to do that?
These are my tables
TblExpenseCategory
ExpenseCategoryID
ExpenseCategory
TblExpenseItem
ExpenseItemID
ExpenseCategoryID
ExpenseItem
TblExpense
ExpenseID
ExpenseDate
Comments
TblExpenseDetail
ExpenseDetailID
ExpenseID
ExpenseItemID
Projected Cost
Actual Cost
Last edited: