[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 388
  • Last Modified:

combo box to open a form from the switchboard

Im doing a simpe CRM sysem but I cant make a como box or list  to open directly a form in any way . I tried :
Select Combobox 34

Case "Name "
strDoc = "form name "
Case Else
end select but nothing happenes

suggestions ?
0
chiefmic
Asked:
chiefmic
  • 15
  • 9
1 Solution
 
Rey Obrero (Capricorn1)Commented:
in what event are you using the codes you posted?

what is the name of the combo box?

here are the event that you can use to open the form
* afterupdate event of the combo

private sub comboName_afterupdate()
dim strDoc as string
strDoc=Me.comboName
docmd.openform strDoc

end sub
* click event of a button


private sub  Button_click()
dim strDoc as string
strDoc=Me.comboName
docmd.openform strDoc

end sub
0
 
chiefmicAuthor Commented:
Ok Im sorry but  my eyes are sqaure by now and  havent being able to do it yet m

I need from a list of employees ( ist box or combo box )

I created in design view and it looks up from the employee tables

I need that each name in the list, if selected, opens the CRM fom tha belong to their name ,

Like
Oscar Omegna
selected opens
FRM_CRM_User_OscarO

the code tat I was using just didnt want to work ,

I just learn all this while I was developing the CRM so if you can be very basic withme tha would be great Thanks  
0
 
chiefmicAuthor Commented:
the name (a lis now ) is list38 ,
 nad th ecodes were in the evenr private sub list38 afterupdate
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
chiefmicAuthor Commented:
sorry I have my right hand with stiches so its a bit harder to write properly , if you cant understand please let me know
0
 
chiefmicAuthor Commented:
forgot to mention im working from the swithcboard
0
 
Rey Obrero (Capricorn1)Commented:
better if you upload a copy of the db.
0
 
chiefmicAuthor Commented:
can i email it to you ?
0
 
chiefmicAuthor Commented:
If Any One can Help Me Please What I need to do is as following :

Instead of the Buttons I put in, I need a list box that opens forms from the switch board( cant seen to work it out ) , And Also that from a new employee entree the required queries and forms are automatically created.

I just being pass to many projects and this one has being taking to much of my time < please let me know if possible and we can work something out
0
 
chiefmicAuthor Commented:
the file
0
 
chiefmicAuthor Commented:
NOw is small enough lol  CRM-1.zip
0
 
Rey Obrero (Capricorn1)Commented:
chiefmic,

what is the purpose of this db application?

why do you have forms for each employees?, you only need one.
0
 
chiefmicAuthor Commented:
Thats where I drop the ball ,

Because I couldn't actually make it work as I want it , (auto creation of forms and stuff) I just work around it and produce a master copy to be added manually ,

The purposeis a crm where each employee can enter the data for new customers and the followed it up , so in each entry they put the details of the customer and it show them where are they , if its waiting , or due ,etc....
I need to know the entries for each employees because some have different functions , and Im work to sort how can i make  , for examples , Sales take care until contract is sign them automatically goes to admin and founding , and after they are done automatic service providers , ( all part of the company ), But im stock in this now . any Ideas??
0
 
Rey Obrero (Capricorn1)Commented:
the first thing that you need to do is to add a field to your table that will hold the name of the employee responsible or who created the record.
do you follow so far?
0
 
chiefmicAuthor Commented:
IM going to upload one with a bit more data in it so you can see what aI mean
0
 
chiefmicAuthor Commented:
0
 
chiefmicAuthor Commented:
Sorry, Yeah I created the employee column in my table
0
 
Rey Obrero (Capricorn1)Commented:
what is the table?
0
 
chiefmicAuthor Commented:
TBL_CRM
0
 
Rey Obrero (Capricorn1)Commented:
what is the name of the field that you added?
0
 
Rey Obrero (Capricorn1)Commented:
chiefmic,
you should not post your email address here..  click on the Request Attention above and ask to remove your email address
0
 
chiefmicAuthor Commented:
Capricorn1, the name of the field is employee name
0
 
Rey Obrero (Capricorn1)Commented:
see this link and download the sample template.
see how the table were designed

http://office.microsoft.com/en-us/templates/CT010142824.aspx?av=ZAC&AxInstalled=1&c=0#ai:TC001225343|
0
 
Rey Obrero (Capricorn1)Commented:
0
 
chiefmicAuthor Commented:
Yeah they are really helpful I guess the best way is to modify one the templates to suit me , and drop the crm .

Still heaps work to do , thanks for you help .

Although Perhaps a Switchboar its all its need it ?
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 15
  • 9
Tackle projects and never again get stuck behind a technical roadblock.
Join Now