spectraflame
Well-known Member
- Joined
- Dec 18, 2002
- Messages
- 830
- Office Version
- 365
- Platform
- Windows
I would like to set the control source of a specific field in my table, but I would like that value based on the lookup of a combo box.
If my combo box, which is pulling data from a query, is APPLES. I would like to have my DESCRIPTION field automatically set to RED. Currently I am doing this for display purposes on my form with =[cboFruit].Column(1) but I would like to store that value in my table.
Is this possible?
Matthew
If my combo box, which is pulling data from a query, is APPLES. I would like to have my DESCRIPTION field automatically set to RED. Currently I am doing this for display purposes on my form with =[cboFruit].Column(1) but I would like to store that value in my table.
Is this possible?
Matthew