D
d9pierce
Hi all,
Before I pull out my last hair on this, I will post this Please Help
on this darn Cmd button issue I am having in hopes of resolving it.
Here is the situation:
I have an Unbound form called "StartUp". This form acts as a
switchboard and only consist of cmd buttons. The Cmd Buttons are as
follows:
Retail Client
SubContractor
Vendor
Mall
I want these to open a form called "Company_Main" which is a bound
form created from a query called "Company_Main_Cities" There are many
different Combo, Txt, and misc... boxes on this form. What I want is
to be able to open this form by clicking one of the above CmdButtons
to a selected txt in a combo box called "CompanyType". Now,
"CompanyType" is a drop down combo box that contain the following
data:
Retail Client
Subcontractor
Vendor
Mall
Now both above Combo and cmd's will have more once I figure this out,
or should I say when We figure this out. but for now this is it.
I want to click Cmd Retail Clients and have the form open showing only
records of Retail Clients. The CompanyType should be filled in "Retail
Clients" and the form should be at this point be filtered. And again
on when Cmd Subcontractors is clicked, this form should open to
Subcontractor and CompanyType should show Subcontractor and so forth
and so on with the rest.
Also, on the form "Company_Main" I need some type of code that when
Retail client or Subcontractor, or Mall is selected from the dropdown
"CompanyType", it makes certain fields in the form visable=True /
Visable=False. This could be on the on current of the form properties.
I would really appriciate any help with this as I am to my wits end
and have tried everything under the sun. Feel free to email me
directly if desired at (e-mail address removed). I check post a lot and if
you need anymore additional information please let me know. I would
also be willing to email over my db. It is very small at the moment so
no big files.
Thans so much!
dave
Before I pull out my last hair on this, I will post this Please Help
on this darn Cmd button issue I am having in hopes of resolving it.
Here is the situation:
I have an Unbound form called "StartUp". This form acts as a
switchboard and only consist of cmd buttons. The Cmd Buttons are as
follows:
Retail Client
SubContractor
Vendor
Mall
I want these to open a form called "Company_Main" which is a bound
form created from a query called "Company_Main_Cities" There are many
different Combo, Txt, and misc... boxes on this form. What I want is
to be able to open this form by clicking one of the above CmdButtons
to a selected txt in a combo box called "CompanyType". Now,
"CompanyType" is a drop down combo box that contain the following
data:
Retail Client
Subcontractor
Vendor
Mall
Now both above Combo and cmd's will have more once I figure this out,
or should I say when We figure this out. but for now this is it.
I want to click Cmd Retail Clients and have the form open showing only
records of Retail Clients. The CompanyType should be filled in "Retail
Clients" and the form should be at this point be filtered. And again
on when Cmd Subcontractors is clicked, this form should open to
Subcontractor and CompanyType should show Subcontractor and so forth
and so on with the rest.
Also, on the form "Company_Main" I need some type of code that when
Retail client or Subcontractor, or Mall is selected from the dropdown
"CompanyType", it makes certain fields in the form visable=True /
Visable=False. This could be on the on current of the form properties.
I would really appriciate any help with this as I am to my wits end
and have tried everything under the sun. Feel free to email me
directly if desired at (e-mail address removed). I check post a lot and if
you need anymore additional information please let me know. I would
also be willing to email over my db. It is very small at the moment so
no big files.
Thans so much!
dave