Need help with combo boxes

[Guest]

I have a table for Billing Categories
Field Names
BillingCategoryID
Description

I have a table for Tasks
Field Names
TaskID
ServiceTask
RateType

I have a table for Task Pricing
Field Names
ContractServiceRateID
BillingCategoryID
TaskID
ServiceRate

I have a main form for billing activity and a sub form for billing activity
details.
On the main form I have a billing category combo box that has previously
been filled in. (this is done by a different person)
On the sub form I have a task combo box. I would like the task combo box to
only show records that relate to the billing category combo box on the main
form.
I cant erase the row source in the task combo box because there are fields
that rely on some of the columns such as =task.column(2).
Can this be done?

 

[Ken Snell [MVP]]

You could add a filter to the combo box's RowSource query to read the value
from the main form's combo box. Post the SQL of the subform's combo box's
RowSource and we'll show you how to add this.