You need to build a query to optain the list you want based upon the current
customer. Then when the user selects the item from the query/browser, pass
it back to the VBForm using the clipboard or export it to a text file and
read it back in.
-----Original Message-----
From: Judy Havlik [mailto:judy.havlik@...]
Sent: Friday, October 31, 2003 11:36 AM
To: vantage@yahoogroups.com
Subject: [Vantage] VantageBasic Forms Design
I started to set up a Combo_Box in the VB Form we use in the Customer.
My pre-defined list was going to be a list of Marketing Campaigns. Our
owner wants the campaigns associated at the Customer level as well as at
the Opportunity/Quote level.
As I started to type the pre-defined list of campaigns, I realized that
when new campaigns are entered or others inactivated in Marketing
Campaigns, I'd always have to remember to go back to this pre-defined VB
Form list and update it.
That got me wondering if there's not a way to link the actual Marketing
Campaign list in the Customer VB Form so that users would always select
from the automatically generated Marketing Campaign list instead a hand
typed pre-defined list.
Sincerely,
Judy Havlik
Plitek, L.L.C.
69 Rawls Road
Des Plaines, IL 60018
Fax: 847-827-6733
PH: 847-827-6680 x223
www.plitek.com
customer. Then when the user selects the item from the query/browser, pass
it back to the VBForm using the clipboard or export it to a text file and
read it back in.
-----Original Message-----
From: Judy Havlik [mailto:judy.havlik@...]
Sent: Friday, October 31, 2003 11:36 AM
To: vantage@yahoogroups.com
Subject: [Vantage] VantageBasic Forms Design
I started to set up a Combo_Box in the VB Form we use in the Customer.
My pre-defined list was going to be a list of Marketing Campaigns. Our
owner wants the campaigns associated at the Customer level as well as at
the Opportunity/Quote level.
As I started to type the pre-defined list of campaigns, I realized that
when new campaigns are entered or others inactivated in Marketing
Campaigns, I'd always have to remember to go back to this pre-defined VB
Form list and update it.
That got me wondering if there's not a way to link the actual Marketing
Campaign list in the Customer VB Form so that users would always select
from the automatically generated Marketing Campaign list instead a hand
typed pre-defined list.
Sincerely,
Judy Havlik
Plitek, L.L.C.
69 Rawls Road
Des Plaines, IL 60018
Fax: 847-827-6733
PH: 847-827-6680 x223
www.plitek.com