Select field from a combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This seems like such a simple thing... that I just can't figure out why I
can't get it!

I need to make a query that displays the value from a combo box from a form
as one of the fields in the Select statement. I tried using the same format
that I use in the Where statement.... but it's not working.

Select Employee.name,
[Forms]![frmMonthEnd]![cmbEnd_Date] AS Period_End,
Employee.SSN
From Employee

Thank you!
Cathy
 
What do you mean it doesn't work? what do you get?
Is the form open when you run the query?

When the form is open, open the immidiate window (Ctrl+G), type in it
?[Forms]![frmMonthEnd]![cmbEnd_Date]

And press enter, what do you get?
 
Ofer,

I get the value in the immediate window. I get a blank in the field as a
result of my query.

I can't figure out why...

Cathy



Ofer Cohen said:
What do you mean it doesn't work? what do you get?
Is the form open when you run the query?

When the form is open, open the immidiate window (Ctrl+G), type in it
?[Forms]![frmMonthEnd]![cmbEnd_Date]

And press enter, what do you get?

--
Good Luck
BS"D


Cathy said:
This seems like such a simple thing... that I just can't figure out why I
can't get it!

I need to make a query that displays the value from a combo box from a form
as one of the fields in the Select statement. I tried using the same format
that I use in the Where statement.... but it's not working.

Select Employee.name,
[Forms]![frmMonthEnd]![cmbEnd_Date] AS Period_End,
Employee.SSN
From Employee

Thank you!
Cathy
Click to expand...
Click to expand...
 
Back
Top