N
NoviceNana
Hi All,
These may be very basic questions (I have fairly basic Access skills)
but here goes...
I'm creating a database to handle a series of vendor contracts. Each
company can have several contracts. On the main form is the name of
the company, address, a field that sums the amount of funding for each
company, and a field that lists the each company's services (drawn
from the subform... see below).
On the subform is the contract number, the service they are providing,
and the dollar amount attached to the contract. Right now I have
between 1 and 7 subforms connected to each main form.
hopefully this is making sense so far. my question is:
I was asked to create a listbox on the main form that pulls together a
list of all the companies services (from the 1- 7 associated
subfields). ie.. I need to pull the services from all of the linked
subforms where the company name on the subform equals the company name
on the mainform and put them in one listbox on the main form. I have
tried a few ways to do this, but I always end up just getting a list of
every service in the database, not just the services tied to the
specific company listed on the main page.
Any help would be greatly greatly appreciated. And again, I'm no where
near an expert programmer so please use as much plain English as
possible
These may be very basic questions (I have fairly basic Access skills)
but here goes...
I'm creating a database to handle a series of vendor contracts. Each
company can have several contracts. On the main form is the name of
the company, address, a field that sums the amount of funding for each
company, and a field that lists the each company's services (drawn
from the subform... see below).
On the subform is the contract number, the service they are providing,
and the dollar amount attached to the contract. Right now I have
between 1 and 7 subforms connected to each main form.
hopefully this is making sense so far. my question is:
I was asked to create a listbox on the main form that pulls together a
list of all the companies services (from the 1- 7 associated
subfields). ie.. I need to pull the services from all of the linked
subforms where the company name on the subform equals the company name
on the mainform and put them in one listbox on the main form. I have
tried a few ways to do this, but I always end up just getting a list of
every service in the database, not just the services tied to the
specific company listed on the main page.
Any help would be greatly greatly appreciated. And again, I'm no where
near an expert programmer so please use as much plain English as
possible