Combo Box Problem

[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?

 

[Guest]

hi,
I think your are talking about what i know as cascading
combos. try this side. it has sample code.
http://www.vb123.com/toolshed/01_access/comboqueries.htm
you can also do a google search on cascading combos.
good luck.