Help with Select Case I think....

M

Michele

I am new to programming and am working on a db for lead managment /CRM. I'm
not sure if what I am trying to do is possible, but any help would be
appreciated. So here it goes.

I have a dispositions dropdown list (Call Back, Left Messgae, Remove from
Call list, etc...)on my subform, on the partnet form contacts, that I need to
have certain actions happen when one of the dispositions is selected. For
example if someone selects "No Equity" I need to be able to append this
record to another table and remove the record form the contacts table. Then
if someone selcets "Application Taken" the record would be appended to a
diffrent table etc... Also if someone selects Call back i need to be able to
open the appointment form based on that record which I can do when it is
independent of the rest I am not sure how to put it all together???

Any help would be appreciated.
 
T

TonyT

Hi Michele,

in the AfterUpdate event of the combobox have your Select Case statement,
I'm assuming you have a hidden 1st column with identifying numbers as the
bound column;
If Not Isnull(Me.Dispositions) Then
Select Case Me.Dispositions

Case 1
DoCmd.OpenForm etc
Case 2
DoCmd.OpenForm2 etc
Case Else
msgbox("please make another selection")
End Select
End If

hope that helps,

TonyT..
 
M

Michele

Thanks Tony that helps, do you also have a suggestion for how to append the
record to another table when a specific disposition is selected so that it is
removed form the leads but so that I can have access to it for marketing
purposes ect...? I guess I need a way to append and delete a record based on
the disposition selection.
 
T

TonyT

Hi again,

You will need 2 SQL statements, the first an INSERT INTO, using SELECT FROM
the relevant table, and the second a simple DELETE code, ahve a read through
help and re-post if you get into any difficulty.

good luck,

TonyT..
 
Top