Combo Box Question

  • Thread starter Thread starter L. Ann
  • Start date Start date
L

L. Ann

I have a combo box that lists my service code and billing rate. I have a
field in my form for billing amount. How can I choose the service code and
have the billing rate automatically enter in the billing amount field? Can it
be done?
 
One way is to use the ComboBox's Column property.

First go to the Combobox properties and change the Column Count to 2.

Then in the Bill Rate text box properties, go to the bill rates control
source and type in

=[cboServiceCode].Column(1)

cboServiceCode is a made up name for the combobox. Insert whatever name you
currently have. Not sure if this answers the question, if not let me know in
more detail what you are trying to accomplish.
 
I have a table with the billing information in it. If I use the table and
select 30.00 it fills in 21.00 in the billing amount. No matter what amount
I select it reduces it. Can you help? Thanks!!!

akphidelt said:
One way is to use the ComboBox's Column property.

First go to the Combobox properties and change the Column Count to 2.

Then in the Bill Rate text box properties, go to the bill rates control
source and type in

=[cboServiceCode].Column(1)

cboServiceCode is a made up name for the combobox. Insert whatever name you
currently have. Not sure if this answers the question, if not let me know in
more detail what you are trying to accomplish.
L. Ann said:
I have a combo box that lists my service code and billing rate. I have a
field in my form for billing amount. How can I choose the service code and
have the billing rate automatically enter in the billing amount field? Can it
be done?
Click to expand...
Click to expand...
 
Alright, maybe im just too dumb to understand the question.

What do you mean if you select 30.00 it fills in 21.00 in the billing
amount. Are you talking about the combobox.column(). Or what is it that you
are doing?

L. Ann said:
I have a table with the billing information in it. If I use the table and
select 30.00 it fills in 21.00 in the billing amount. No matter what amount
I select it reduces it. Can you help? Thanks!!!

akphidelt said:
One way is to use the ComboBox's Column property.

First go to the Combobox properties and change the Column Count to 2.

Then in the Bill Rate text box properties, go to the bill rates control
source and type in

=[cboServiceCode].Column(1)

cboServiceCode is a made up name for the combobox. Insert whatever name you
currently have. Not sure if this answers the question, if not let me know in
more detail what you are trying to accomplish.
L. Ann said:
I have a combo box that lists my service code and billing rate. I have a
field in my form for billing amount. How can I choose the service code and
have the billing rate automatically enter in the billing amount field? Can it
be done?
Click to expand...
Click to expand...
Click to expand...
 
Sorry I didn't explain it in detail. I have a table that is titled Workorder
Labor. It has fields of billing hours; billing amount; and employee. Then, I
have another table titled Labor Codes that has fields; CodeID; service code;
code description; and billing rate. Ex. SC - Service Call - $70.00; NC - New
Connect - $30.00, etc. In my form, it is based on the Workorder Labor table.
I created a combo box linking it to the Labor Code table with the ID hidden
and the billing rate as the first column. When I choose $30.00 - NC - New
Connect it will enter $21.00 in the billing rate field in the Workorder Labor
table. Hope this makes sense. What I am wanting to do is lookup the service
code and automatically enter that rate in the billing rate field on the form.
Thanks! Ann

akphidelt said:
Alright, maybe im just too dumb to understand the question.

What do you mean if you select 30.00 it fills in 21.00 in the billing
amount. Are you talking about the combobox.column(). Or what is it that you
are doing?

L. Ann said:
I have a table with the billing information in it. If I use the table and
select 30.00 it fills in 21.00 in the billing amount. No matter what amount
I select it reduces it. Can you help? Thanks!!!

akphidelt said:
One way is to use the ComboBox's Column property.

First go to the Combobox properties and change the Column Count to 2.

Then in the Bill Rate text box properties, go to the bill rates control
source and type in

=[cboServiceCode].Column(1)

cboServiceCode is a made up name for the combobox. Insert whatever name you
currently have. Not sure if this answers the question, if not let me know in
more detail what you are trying to accomplish.
:

I have a combo box that lists my service code and billing rate. I have a
field in my form for billing amount. How can I choose the service code and
have the billing rate automatically enter in the billing amount field? Can it
be done?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top