Hi
Your requirements are not clear. Can you share a screenshot of where you want the combo box and the underline table for your category?

Yeah, how is everything set up? Are these related tables?

Hi gentlemen, thank you for getting back with me.  

So, I have a table "T_Transactions", where all transactions go into.  A table "T_Payee", where payees are listed and selected for new transactions, and a table "T_Expenses_Acct", where expense accts. (or categories) are listed and selected for new transactions.  

I downloaded transactions from my bank and credit card comp. websites and formatted in Excel to import into my Access database.  After being almost caught-up with the selection of payees and corresponding expense acct on all the transactions, I thought that it would have been nice to select the Payee and have the expense acct. automatically populated, essentially use a Combo Box that uses VBA programming to do it.  I tried it in a test form and it works, but can't figure out how to implement that in my existing "F_Transactions" form without affecting the payees and corresponding expense acct already in each transaction.

I have uploaded screenshots of the 3 tables and my form.  I'm having tons and tons of fun setting up different Access databases, my first ones after YEARS of doing EVERYTNING in Excel.

Your guidance is greatly appreciated.  

Best regards,

Juan

Let me understand you correctly. You are saying there is a relationship between Payee and Expense accounts? that the payee should determine the Expense account?

you said:
" it would have been nice to select the Payee and have the expense acct. automatically populated"

please clarify