J
jonah
background:
I have two comboboxes on a form. The same form also has
a couple subforms. The second combobox (cbxsubtype) is
dependent on the entry in the first combobox (cbxtype).
Currently, the cbxtype is simply populated from a zlookup
table (zlookup type). The primary underlying table is
tblissuedata.
Here is my problem - I am trying to modify cbxtype so
that it is dependent on a condition. The condition can
be identified from tblissuedata.methodid. The methodid
should limit the cbxtype from the full set (8) of options
in zlookup type to only 6. However when I try to set up
the data source for cbxtype, I either get a parameter box
that asks me for input, or I get a over 300 options to
select from. zlookup type only has about 8 entries that
are being duplicated in cbxtype.
My zlookup type table currently has a field IorN that
indicates whether a record would be included in cbxtype
or not.
Currently I also have a IorN field in my tblmethod. It
is whith the IorN fields that I am trying to link the
tables together.
Does that all make sense?
I am guessing my query is messed up or I need to
straighten out relationships - but nothing I try is
working.
Please help! TIA
Jonah
I have two comboboxes on a form. The same form also has
a couple subforms. The second combobox (cbxsubtype) is
dependent on the entry in the first combobox (cbxtype).
Currently, the cbxtype is simply populated from a zlookup
table (zlookup type). The primary underlying table is
tblissuedata.
Here is my problem - I am trying to modify cbxtype so
that it is dependent on a condition. The condition can
be identified from tblissuedata.methodid. The methodid
should limit the cbxtype from the full set (8) of options
in zlookup type to only 6. However when I try to set up
the data source for cbxtype, I either get a parameter box
that asks me for input, or I get a over 300 options to
select from. zlookup type only has about 8 entries that
are being duplicated in cbxtype.
My zlookup type table currently has a field IorN that
indicates whether a record would be included in cbxtype
or not.
Currently I also have a IorN field in my tblmethod. It
is whith the IorN fields that I am trying to link the
tables together.
Does that all make sense?
I am guessing my query is messed up or I need to
straighten out relationships - but nothing I try is
working.
Please help! TIA
Jonah