criteria from queried combo box

[Guest]

Hi, I have read several posts on this topic and still can't quite figure it
out.

I have a combo box on a form called CSRList. It is populated from a query
with this in the row source:

SELECT [CSR By Team].USERID, [CSR By Team].LASTNAME, [CSR By Team].FIRSTNAME
FROM [CSR By Team] ORDER BY [LASTNAME];

Only when you use the combo box, all 3 fields show up, but when you click on
one, only the USERID is shown on the form. That is fine with me.

My problem is now after I choose a user from the combo box, I want to run a
query (say query1) with the USERID from the combo box, as the criteria in my
USERID field of query1.

This is what I have for the criteria there (CSR Breakdown is the name of the
form):

[Forms].[CSR Breakdown].[CSRList]

This is not bringing any data up when it should. What am I doing wrong? Is
it because I am trying to pull from a queried combo box?

Thanks in advance,

Nick

 

[Bob M via AccessMonster.com]

Did you put = in front of the criteria?

Hi, I have read several posts on this topic and still can't quite figure it
out.

I have a combo box on a form called CSRList. It is populated from a query
with this in the row source:

SELECT [CSR By Team].USERID, [CSR By Team].LASTNAME, [CSR By Team].FIRSTNAME
FROM [CSR By Team] ORDER BY [LASTNAME];

Only when you use the combo box, all 3 fields show up, but when you click on
one, only the USERID is shown on the form. That is fine with me.

My problem is now after I choose a user from the combo box, I want to run a
query (say query1) with the USERID from the combo box, as the criteria in my
USERID field of query1.

This is what I have for the criteria there (CSR Breakdown is the name of the
form):

[Forms].[CSR Breakdown].[CSRList]

This is not bringing any data up when it should. What am I doing wrong? Is
it because I am trying to pull from a queried combo box?

Thanks in advance,

Nick

 

[Guest]

Actually I just figured it out, using a msgbox to test what field the combo
box has as its value. The "Bound Column" box told me. Thanks though.

Did you put = in front of the criteria?

Hi, I have read several posts on this topic and still can't quite figure it
out.

I have a combo box on a form called CSRList. It is populated from a query
with this in the row source:

SELECT [CSR By Team].USERID, [CSR By Team].LASTNAME, [CSR By Team].FIRSTNAME
FROM [CSR By Team] ORDER BY [LASTNAME];

Only when you use the combo box, all 3 fields show up, but when you click on
one, only the USERID is shown on the form. That is fine with me.

My problem is now after I choose a user from the combo box, I want to run a
query (say query1) with the USERID from the combo box, as the criteria in my
USERID field of query1.

This is what I have for the criteria there (CSR Breakdown is the name of the
form):

[Forms].[CSR Breakdown].[CSRList]

This is not bringing any data up when it should. What am I doing wrong? Is
it because I am trying to pull from a queried combo box?

Thanks in advance,

Nick