Help Needed with Combo box

[pr2-eugin]

Hmm.. See the attached changes..

 

[Crabbymcdo]

Ah right ok got ya but how do I stop the closed ones from showing in the drop down I can see you have done it in the copy of frmcallloggedpage but I cant see how you have done it

 

[pr2-eugin]

Click the ComboBox and then the RowSource, you will see the SELECT Statement, similar to the FormCloseDetails RecordSource added a Criteria..

WHERE Out = False

On a (ir)relevant side note, if you are in a position to change names, please follow a standard Naming convention.. Makes it a lot more easier.. Reading FormDetailsClose, WelcomeForm is so much easier than formdetailsclose, welcomeform..

 

[Crabbymcdo]

Ok final question, in my original post, I would receive an email when the call has been closed, how can I now reincorp this as it now doesn't work,

 

[Crabbymcdo]

ahhhh fixed it, thanks so much

 

[pr2-eugin]

Finally !! Yay.. Okay good luck..