0

i don't know how to get value from combo box. I select one of firm on combo box

SELECT [Worker].[Firm] 
FROM [Worker] 
WHERE [Worker].[Firm] = X 
ORDER BY [Firm];

what i need to type for X? combo.Text don't work

nitz
  • 53
  • 1
  • 5

2 Answers2

0

combo itself is enough.

However, you may need to use Forms![name of form]!combo

E Mett
  • 2,272
  • 3
  • 18
  • 37
0

Try Me.combo. That's how I got the value from my combobox. Also, as a naming convention it's good practice to use cbo as a prefix, then a descriptive label for the combobox, i.e. if it's for a date, cboDate.

user2521720
  • 59
  • 1
  • 3
  • 7