Create combo box in Form to look up values in a table

Teddy

Registered User.
Local time
Today, 13:47
Joined
Dec 19, 2009
Messages
10
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

 
Last edited:
Right click on the combo box and select properties.(design view)
Select the Data tab and change the 'Row Source Type' to 'Table/Query'
Then click into 'Row Source' and click the three dots to the right of it.
From there add the table and the field you want to use.
If you are using more than 1 field you will have to change other settings.
 
Solved

Thank you so much. This is very helpful to me. I am very grateful for your help.
 
Last edited:

Users who are viewing this thread

Back
Top Bottom