|
 |
access thread: [Access] Filtering data in a combo box - again
Message #1 by Michelle Madden <MichelleM@a...> on Mon, 26 Mar 2001 13:11:28 +0100
|
|
Hi,
Can anyone help again?
I have two fields COMPANY and CONTACT, both these fields are combo boxes.
What I would like is to select a company in the first field, and the second
field only display the contacts belonging to that company.
The fields are updating a table of call information, but the records
themselves come from COMPANY_INFORMATION and CONTACT_INFORMATION with the
join being COMPANY_ID.
As this is all very new to me I have tried various things without success
and don't know any VB code.
Can I do this with a select statement and select all the columns where the
company_id is equal to the company_id entered in the form field? Or is there
another way of doing this?
Someone has replied to this but I didn't understand the full instructions.
Thanks
Michelle
Message #2 by "Craig Flannigan" <ckf@k...> on Mon, 26 Mar 2001 13:20:46 +0100
|
|
Michelle,
The data that is in the second Combo box - is it a lot of
information? How many records are we talking?
Craig.
-----Original Message-----
From: Michelle Madden [mailto:MichelleM@a...]
Sent: 26 March 2001 01:11 PM
To: Access
Subject: [access] [Access] Filtering data in a combo box -
again
Hi,
Can anyone help again?
I have two fields COMPANY and CONTACT, both these fields are
combo boxes.
What I would like is to select a company in the first field,
and the second
field only display the contacts belonging to that company.
The fields are updating a table of call information, but the
records
themselves come from COMPANY_INFORMATION and
CONTACT_INFORMATION with the
join being COMPANY_ID.
As this is all very new to me I have tried various things
without success
and don't know any VB code.
Can I do this with a select statement and select all the
columns where the
company_id is equal to the company_id entered in the form
field? Or is there
another way of doing this?
Someone has replied to this but I didn't understand the full
instructions.
Thanks
Michelle
Message #3 by Michelle Madden <MichelleM@a...> on Mon, 26 Mar 2001 14:03:33 +0100
|
|
Hi Craig,
Thanks for replying.
No, I don't think its going to be much, maybe a maximum of 20 - 30 contacts
per client, but normally 4 or 5.
Just to let you know, I'm not a programmer and I don't know access that well
so any explanation needs to be in detail - as I'm pretty thick :-)
Thanks again,
Michelle
-----Original Message-----
From: Craig Flannigan [mailto:ckf@k...]
Sent: 26 March 2001 13:21
To: Access
Subject: [access] RE: [Access] Filtering data in a combo box - again
Michelle,
The data that is in the second Combo box - is it a lot of
information? How many records are we talking?
Craig.
-----Original Message-----
From: Michelle Madden [mailto:MichelleM@a...]
Sent: 26 March 2001 01:11 PM
To: Access
Subject: [access] [Access] Filtering data in a combo box -
again
Hi,
Can anyone help again?
I have two fields COMPANY and CONTACT, both these fields are
combo boxes.
What I would like is to select a company in the first field,
and the second
field only display the contacts belonging to that company.
The fields are updating a table of call information, but the
records
themselves come from COMPANY_INFORMATION and
CONTACT_INFORMATION with the
join being COMPANY_ID.
As this is all very new to me I have tried various things
without success
and don't know any VB code.
Can I do this with a select statement and select all the
columns where the
company_id is equal to the company_id entered in the form
field? Or is there
another way of doing this?
Someone has replied to this but I didn't understand the full
instructions.
Thanks
Michelle
Message #4 by "John Ruff" <papparuff@c...> on Mon, 26 Mar 2001 07:54:35 -0800
|
|
Michelle,
Go to Microsoft's Knowledgebase and lookup article ID Q98660, How to Create
Synchronized Combo Boxes. It provides you with the code to perform the task
you are asking about. Here is the URL:
http://support.microsoft.com/support/kb/articles/Q98/6/60.ASP?LN=EN-US&SD=gn
&FR=0&qry=Q98660&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=OFW97
Also, the knowledgebase this code comes from is downloadable. (I have been
using the download for over three years). The Article ID is Q167120 and the
URL is:
http://support.microsoft.com/support/kb/articles/Q167/1/20.asp?LN=EN-US&SD=g
n&FR=0&qry=Q167120&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC97
The file name is Acc97KB.exe It is a powerful tool providing excellent
coding examples.
John Ruff - The Eternal Optimist :)
-----Original Message-----
From: Michelle Madden [mailto:MichelleM@a...]
Sent: Monday, March 26, 2001 4:11 AM
To: Access
Subject: [access] [Access] Filtering data in a combo box - again
Hi,
Can anyone help again?
I have two fields COMPANY and CONTACT, both these fields are combo boxes.
What I would like is to select a company in the first field, and the second
field only display the contacts belonging to that company.
The fields are updating a table of call information, but the records
themselves come from COMPANY_INFORMATION and CONTACT_INFORMATION with the
join being COMPANY_ID.
As this is all very new to me I have tried various things without success
and don't know any VB code.
Can I do this with a select statement and select all the columns where the
company_id is equal to the company_id entered in the form field? Or is there
another way of doing this?
Someone has replied to this but I didn't understand the full instructions.
Thanks
Michelle
|
|
|
View Cart
