D
Dave Birley
My form is ultra simple -- but then, be patient with me -- I am a VFP
programmer, not an Access programmer, so I understand relational DATA, but
not how to tie it together in Access <g>!
Here it is: Combo box, based on a table, Company (6 records -- that's right
SIX!)
CompanyID AutoNum
Company Text
SubForm containing Listbox based on a table Payload (3 records -- in case
they change criteria)
PayloadID AutoNum
Payload Text
Subform containing Listbox based on query displaying Item, filtered by
Company and Payload
In this mix is a Table called Group which ties Company and payload together
by ID only, and the Group table is supposed to drive the query for the Item
listbox.
The Item table has fields
ItemID AutoNum
GroupID Numeric
Item Text
Reference_Address Hyperlink
The Reference_Address field is present in the query driving the subform, but
not displayed (hidden by putting it on the right and turning off the
horizontal scroll). It's content is called with a button which I have working
on a different form and I will copy for this form.
Now, with any luck I've give y'all enough information!
The problem is that when I select a different company in the Combobox or a
different payload, nothing changes in the Item list -- all items are
displayed all the time. Therefore, obviously I have no filtering in place.
I sit obediently at the feet of the gurus awaiting further light and
knowledge.
programmer, not an Access programmer, so I understand relational DATA, but
not how to tie it together in Access <g>!
Here it is: Combo box, based on a table, Company (6 records -- that's right
SIX!)
CompanyID AutoNum
Company Text
SubForm containing Listbox based on a table Payload (3 records -- in case
they change criteria)
PayloadID AutoNum
Payload Text
Subform containing Listbox based on query displaying Item, filtered by
Company and Payload
In this mix is a Table called Group which ties Company and payload together
by ID only, and the Group table is supposed to drive the query for the Item
listbox.
The Item table has fields
ItemID AutoNum
GroupID Numeric
Item Text
Reference_Address Hyperlink
The Reference_Address field is present in the query driving the subform, but
not displayed (hidden by putting it on the right and turning off the
horizontal scroll). It's content is called with a button which I have working
on a different form and I will copy for this form.
Now, with any luck I've give y'all enough information!
The problem is that when I select a different company in the Combobox or a
different payload, nothing changes in the Item list -- all items are
displayed all the time. Therefore, obviously I have no filtering in place.
I sit obediently at the feet of the gurus awaiting further light and
knowledge.