I want Combo box to be populated depending on customer category

  • Thread starter Thread starter Sue R
  • Start date Start date
S

Sue R

When a customer number is entered on my form, the data populates the form,
including the text box for the customer category.

I want a combo box on that form to display only choices for that category.

How do I modify the query that runs the row source for the combo box?

Thanks,

Sue
 
On Thu, 7 Jan 2010 21:47:01 -0800, Sue R

The RowSource should be something like:
select * from Choices
where Category = Forms!myForm!myCategoryTextbox

-Tom.
Microsoft Access MVP
 
In the Row Source for the combo box I have entered:

WHERE ((([UNITCOST BY CONTRACT].Dept)="MH") AND (([UNITCOST BY
CONTRACT].CONTRACT)=Forms![Monthly Input Invoice and MTR]!ClientContract))

It still doesn't work. Help, I am pulling my hair out and my head is
getting sore!

Sue
 
In the Row Source for the combo box I have entered:

WHERE ((([UNITCOST BY CONTRACT].Dept)="MH") AND (([UNITCOST BY
CONTRACT].CONTRACT)=Forms![Monthly Input Invoice and MTR]!ClientContract))

It still doesn't work. Help, I am pulling my hair out and my head is
getting sore!
Click to expand...

YOu may also need to Requery this combo in the AfterUpdate event of the
ClientContract control.
 
Still no luck,

Maybe more info will help.

My form is 'Monthly Input Invoice and MTR'

The client number is entered in the form and the client's contract number
populates the text box called 'ClientContract'

The further down on the form, I want the user to click on a combo box for
'project code' choices. There are hundreds of project codes, but I only want
the project codes selected to be those that have the same contract number
that the client has in the 'ClientContract' text box.

The project codes are stored in a table called 'Unitcost by Contract'.

I hope this helps, I am going nuts trying to figure this out.

Thanks in advance!

Sue




John W. Vinson said:
In the Row Source for the combo box I have entered:

WHERE ((([UNITCOST BY CONTRACT].Dept)="MH") AND (([UNITCOST BY
CONTRACT].CONTRACT)=Forms![Monthly Input Invoice and MTR]!ClientContract))

It still doesn't work. Help, I am pulling my hair out and my head is
getting sore!
Click to expand...

YOu may also need to Requery this combo in the AfterUpdate event of the
ClientContract control.
Click to expand...
 
Below you say "In the Row Source for the combo box I have entered:"

" WHERE ((([UNITCOST BY CONTRACT].Dept)="MH") AND (([UNITCOST BY
CONTRACT].CONTRACT)=Forms![Monthly Input Invoice and MTR]!ClientContract))
"

This is only part of a query.
Where is the SELECT part?



Sue said:
Still no luck,

Maybe more info will help.

My form is 'Monthly Input Invoice and MTR'

The client number is entered in the form and the client's contract
number populates the text box called 'ClientContract'

The further down on the form, I want the user to click on a combo box
for 'project code' choices. There are hundreds of project codes, but
I only want the project codes selected to be those that have the same
contract number that the client has in the 'ClientContract' text box.

The project codes are stored in a table called 'Unitcost by Contract'.

I hope this helps, I am going nuts trying to figure this out.

Thanks in advance!

Sue




John W. Vinson said:
In the Row Source for the combo box I have entered:

WHERE ((([UNITCOST BY CONTRACT].Dept)="MH") AND (([UNITCOST BY
CONTRACT].CONTRACT)=Forms![Monthly Input Invoice and
MTR]!ClientContract))

It still doesn't work. Help, I am pulling my hair out and my head
is getting sore!
Click to expand...

YOu may also need to Requery this combo in the AfterUpdate event of
the ClientContract control.
Click to expand...
Click to expand...
 
Thanks for the quick response. Here is the exact code from the Row Source in
the codebox property. (I removed the '(([UNITCOST BY CONTRACT].Dept)="MH")',
as I didn't really need it.)

SELECT DISTINCTROW [UNITCOST BY CONTRACT].Service, [UNITCOST BY
CONTRACT].NAME, [UNITCOST BY CONTRACT].UNITP, [UNITCOST BY CONTRACT].CONTRACT
FROM MTR_Entry LEFT JOIN [UNITCOST BY CONTRACT] ON MTR_Entry.Contract =
[UNITCOST BY CONTRACT].CONTRACT ORDER BY [UNITCOST BY CONTRACT].Service;

Sue

Mike Painter said:
Below you say "In the Row Source for the combo box I have entered:"

" WHERE ((([UNITCOST BY CONTRACT].Dept)="MH") AND (([UNITCOST BY
CONTRACT].CONTRACT)=Forms![Monthly Input Invoice and MTR]!ClientContract))
"

This is only part of a query.
Where is the SELECT part?



Sue said:
Still no luck,

Maybe more info will help.

My form is 'Monthly Input Invoice and MTR'

The client number is entered in the form and the client's contract
number populates the text box called 'ClientContract'

The further down on the form, I want the user to click on a combo box
for 'project code' choices. There are hundreds of project codes, but
I only want the project codes selected to be those that have the same
contract number that the client has in the 'ClientContract' text box.

The project codes are stored in a table called 'Unitcost by Contract'.

I hope this helps, I am going nuts trying to figure this out.

Thanks in advance!

Sue




John W. Vinson said:
On Fri, 8 Jan 2010 17:00:01 -0800, Sue R

In the Row Source for the combo box I have entered:

WHERE ((([UNITCOST BY CONTRACT].Dept)="MH") AND (([UNITCOST BY
CONTRACT].CONTRACT)=Forms![Monthly Input Invoice and
MTR]!ClientContract))

It still doesn't work. Help, I am pulling my hair out and my head
is getting sore!

YOu may also need to Requery this combo in the AfterUpdate event of
the ClientContract control.
Click to expand...
Click to expand...


.
Click to expand...
 
Did you requery the combobox after entering a value in ClientContact?
If so, which event did you use?
Sue said:
Thanks for the quick response. Here is the exact code from the Row
Source in the codebox property. (I removed the '(([UNITCOST BY
CONTRACT].Dept)="MH")', as I didn't really need it.)

SELECT DISTINCTROW [UNITCOST BY CONTRACT].Service, [UNITCOST BY
CONTRACT].NAME, [UNITCOST BY CONTRACT].UNITP, [UNITCOST BY
CONTRACT].CONTRACT FROM MTR_Entry LEFT JOIN [UNITCOST BY CONTRACT] ON
MTR_Entry.Contract = [UNITCOST BY CONTRACT].CONTRACT ORDER BY
[UNITCOST BY CONTRACT].Service;

Sue

Mike Painter said:
Below you say "In the Row Source for the combo box I have entered:"

" WHERE ((([UNITCOST BY CONTRACT].Dept)="MH") AND (([UNITCOST BY
CONTRACT].CONTRACT)=Forms![Monthly Input Invoice and
MTR]!ClientContract)) "

This is only part of a query.
Where is the SELECT part?



Sue said:
Still no luck,

Maybe more info will help.

My form is 'Monthly Input Invoice and MTR'

The client number is entered in the form and the client's contract
number populates the text box called 'ClientContract'

The further down on the form, I want the user to click on a combo
box for 'project code' choices. There are hundreds of project
codes, but I only want the project codes selected to be those that
have the same contract number that the client has in the
'ClientContract' text box.

The project codes are stored in a table called 'Unitcost by
Contract'.

I hope this helps, I am going nuts trying to figure this out.

Thanks in advance!

Sue




:

On Fri, 8 Jan 2010 17:00:01 -0800, Sue R

In the Row Source for the combo box I have entered:

WHERE ((([UNITCOST BY CONTRACT].Dept)="MH") AND (([UNITCOST BY
CONTRACT].CONTRACT)=Forms![Monthly Input Invoice and
MTR]!ClientContract))

It still doesn't work. Help, I am pulling my hair out and my head
is getting sore!

YOu may also need to Requery this combo in the AfterUpdate event of
the ClientContract control.
Click to expand...


.
Click to expand...
Click to expand...
 
Yes, I put a macro to requery the Combo box 'Codebox' in the after update
event of the ClientContract text box.

Mike Painter said:
Did you requery the combobox after entering a value in ClientContact?
If so, which event did you use?
Sue said:
Thanks for the quick response. Here is the exact code from the Row
Source in the codebox property. (I removed the '(([UNITCOST BY
CONTRACT].Dept)="MH")', as I didn't really need it.)

SELECT DISTINCTROW [UNITCOST BY CONTRACT].Service, [UNITCOST BY
CONTRACT].NAME, [UNITCOST BY CONTRACT].UNITP, [UNITCOST BY
CONTRACT].CONTRACT FROM MTR_Entry LEFT JOIN [UNITCOST BY CONTRACT] ON
MTR_Entry.Contract = [UNITCOST BY CONTRACT].CONTRACT ORDER BY
[UNITCOST BY CONTRACT].Service;

Sue

Mike Painter said:
Below you say "In the Row Source for the combo box I have entered:"

" WHERE ((([UNITCOST BY CONTRACT].Dept)="MH") AND (([UNITCOST BY
CONTRACT].CONTRACT)=Forms![Monthly Input Invoice and
MTR]!ClientContract)) "

This is only part of a query.
Where is the SELECT part?



Sue R wrote:
Still no luck,

Maybe more info will help.

My form is 'Monthly Input Invoice and MTR'

The client number is entered in the form and the client's contract
number populates the text box called 'ClientContract'

The further down on the form, I want the user to click on a combo
box for 'project code' choices. There are hundreds of project
codes, but I only want the project codes selected to be those that
have the same contract number that the client has in the
'ClientContract' text box.

The project codes are stored in a table called 'Unitcost by
Contract'.

I hope this helps, I am going nuts trying to figure this out.

Thanks in advance!

Sue




:

On Fri, 8 Jan 2010 17:00:01 -0800, Sue R

In the Row Source for the combo box I have entered:

WHERE ((([UNITCOST BY CONTRACT].Dept)="MH") AND (([UNITCOST BY
CONTRACT].CONTRACT)=Forms![Monthly Input Invoice and
MTR]!ClientContract))

It still doesn't work. Help, I am pulling my hair out and my head
is getting sore!

YOu may also need to Requery this combo in the AfterUpdate event of
the ClientContract control.
--

John W. Vinson [MVP]
.


.
Click to expand...
Click to expand...


.
Click to expand...
 
Is this box bound to anything? If not I don't think it triggers. Try OnExit.

Sue said:
Yes, I put a macro to requery the Combo box 'Codebox' in the after
update event of the ClientContract text box.

Mike Painter said:
Did you requery the combobox after entering a value in ClientContact?
If so, which event did you use?
Sue said:
Thanks for the quick response. Here is the exact code from the Row
Source in the codebox property. (I removed the '(([UNITCOST BY
CONTRACT].Dept)="MH")', as I didn't really need it.)

SELECT DISTINCTROW [UNITCOST BY CONTRACT].Service, [UNITCOST BY
CONTRACT].NAME, [UNITCOST BY CONTRACT].UNITP, [UNITCOST BY
CONTRACT].CONTRACT FROM MTR_Entry LEFT JOIN [UNITCOST BY CONTRACT]
ON MTR_Entry.Contract = [UNITCOST BY CONTRACT].CONTRACT ORDER BY
[UNITCOST BY CONTRACT].Service;

Sue

:

Below you say "In the Row Source for the combo box I have entered:"

" WHERE ((([UNITCOST BY CONTRACT].Dept)="MH") AND (([UNITCOST BY
CONTRACT].CONTRACT)=Forms![Monthly Input Invoice and
MTR]!ClientContract)) "

This is only part of a query.
Where is the SELECT part?



Sue R wrote:
Still no luck,

Maybe more info will help.

My form is 'Monthly Input Invoice and MTR'

The client number is entered in the form and the client's contract
number populates the text box called 'ClientContract'

The further down on the form, I want the user to click on a combo
box for 'project code' choices. There are hundreds of project
codes, but I only want the project codes selected to be those that
have the same contract number that the client has in the
'ClientContract' text box.

The project codes are stored in a table called 'Unitcost by
Contract'.

I hope this helps, I am going nuts trying to figure this out.

Thanks in advance!

Sue




:

On Fri, 8 Jan 2010 17:00:01 -0800, Sue R

In the Row Source for the combo box I have entered:

WHERE ((([UNITCOST BY CONTRACT].Dept)="MH") AND (([UNITCOST BY
CONTRACT].CONTRACT)=Forms![Monthly Input Invoice and
MTR]!ClientContract))

It still doesn't work. Help, I am pulling my hair out and my
head is getting sore!

YOu may also need to Requery this combo in the AfterUpdate event
of the ClientContract control.
--

John W. Vinson [MVP]
.


.
Click to expand...


.
Click to expand...
Click to expand...
 
The text box is autofilled when the customer number is first entered. It is
really only for display purposes, and to use as a reference for the combo box.

Mike Painter said:
Is this box bound to anything? If not I don't think it triggers. Try OnExit.

Sue said:
Yes, I put a macro to requery the Combo box 'Codebox' in the after
update event of the ClientContract text box.

Mike Painter said:
Did you requery the combobox after entering a value in ClientContact?
If so, which event did you use?
Sue R wrote:
Thanks for the quick response. Here is the exact code from the Row
Source in the codebox property. (I removed the '(([UNITCOST BY
CONTRACT].Dept)="MH")', as I didn't really need it.)

SELECT DISTINCTROW [UNITCOST BY CONTRACT].Service, [UNITCOST BY
CONTRACT].NAME, [UNITCOST BY CONTRACT].UNITP, [UNITCOST BY
CONTRACT].CONTRACT FROM MTR_Entry LEFT JOIN [UNITCOST BY CONTRACT]
ON MTR_Entry.Contract = [UNITCOST BY CONTRACT].CONTRACT ORDER BY
[UNITCOST BY CONTRACT].Service;

Sue

:

Below you say "In the Row Source for the combo box I have entered:"

" WHERE ((([UNITCOST BY CONTRACT].Dept)="MH") AND (([UNITCOST BY
CONTRACT].CONTRACT)=Forms![Monthly Input Invoice and
MTR]!ClientContract)) "

This is only part of a query.
Where is the SELECT part?



Sue R wrote:
Still no luck,

Maybe more info will help.

My form is 'Monthly Input Invoice and MTR'

The client number is entered in the form and the client's contract
number populates the text box called 'ClientContract'

The further down on the form, I want the user to click on a combo
box for 'project code' choices. There are hundreds of project
codes, but I only want the project codes selected to be those that
have the same contract number that the client has in the
'ClientContract' text box.

The project codes are stored in a table called 'Unitcost by
Contract'.

I hope this helps, I am going nuts trying to figure this out.

Thanks in advance!

Sue




:

On Fri, 8 Jan 2010 17:00:01 -0800, Sue R

In the Row Source for the combo box I have entered:

WHERE ((([UNITCOST BY CONTRACT].Dept)="MH") AND (([UNITCOST BY
CONTRACT].CONTRACT)=Forms![Monthly Input Invoice and
MTR]!ClientContract))

It still doesn't work. Help, I am pulling my hair out and my
head is getting sore!

YOu may also need to Requery this combo in the AfterUpdate event
of the ClientContract control.
--

John W. Vinson [MVP]
.


.


.
Click to expand...
Click to expand...


.
Click to expand...
 
"Autofilled"!? This should have been mentioned some time ago.
Then you need to requery the combo-box from where ever that value comes
from.

Sue said:
The text box is autofilled when the customer number is first entered.
It is really only for display purposes, and to use as a reference for
the combo box.

Mike Painter said:
Is this box bound to anything? If not I don't think it triggers. Try
OnExit.

Sue said:
Yes, I put a macro to requery the Combo box 'Codebox' in the after
update event of the ClientContract text box.

:

Did you requery the combobox after entering a value in
ClientContact? If so, which event did you use?
Sue R wrote:
Thanks for the quick response. Here is the exact code from the Row
Source in the codebox property. (I removed the '(([UNITCOST BY
CONTRACT].Dept)="MH")', as I didn't really need it.)

SELECT DISTINCTROW [UNITCOST BY CONTRACT].Service, [UNITCOST BY
CONTRACT].NAME, [UNITCOST BY CONTRACT].UNITP, [UNITCOST BY
CONTRACT].CONTRACT FROM MTR_Entry LEFT JOIN [UNITCOST BY CONTRACT]
ON MTR_Entry.Contract = [UNITCOST BY CONTRACT].CONTRACT ORDER BY
[UNITCOST BY CONTRACT].Service;

Sue

:

Below you say "In the Row Source for the combo box I have
entered:"

" WHERE ((([UNITCOST BY CONTRACT].Dept)="MH") AND (([UNITCOST BY
CONTRACT].CONTRACT)=Forms![Monthly Input Invoice and
MTR]!ClientContract)) "

This is only part of a query.
Where is the SELECT part?



Sue R wrote:
Still no luck,

Maybe more info will help.

My form is 'Monthly Input Invoice and MTR'

The client number is entered in the form and the client's
contract number populates the text box called 'ClientContract'

The further down on the form, I want the user to click on a
combo box for 'project code' choices. There are hundreds of
project codes, but I only want the project codes selected to be
those that have the same contract number that the client has in
the 'ClientContract' text box.

The project codes are stored in a table called 'Unitcost by
Contract'.

I hope this helps, I am going nuts trying to figure this out.

Thanks in advance!

Sue




:

On Fri, 8 Jan 2010 17:00:01 -0800, Sue R

In the Row Source for the combo box I have entered:

WHERE ((([UNITCOST BY CONTRACT].Dept)="MH") AND (([UNITCOST BY
CONTRACT].CONTRACT)=Forms![Monthly Input Invoice and
MTR]!ClientContract))

It still doesn't work. Help, I am pulling my hair out and my
head is getting sore!

YOu may also need to Requery this combo in the AfterUpdate
event of the ClientContract control.
--

John W. Vinson [MVP]
.


.


.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top