I am not a programmer, and do not know SQL very well. So in the property of the combo box I am wanting a message to come up if “hotline” was chosen to bring up a message that says “input Tier in the tier field”
Hi. Sounds like your calling "code," SQL. Okay. When we hear "code," we think of VBA. So, to display a message, you can use either VBA or a macro. Sounds like you would like to use a macro. If so, in the AfterUpdate event of your Combobox, click on the three dots (ellipsis ...) and select Macro Builder. Then, look for the MessageBox action. You would also need the If action to test what the user selected from the dropdown.
By selecting the responsibility field in design view, I put the msg box in the After Update on the property sheet. I only want the message to come up when Hotline is chosen - what would the If statement be and where in the design property sheet would I put it? All help is VERY appreciated.
Hi. No, you don't put MsgBox() in the property itself. Leave it blank and just click on the three dots next to it (to the right). You would then select Macro Builder from the option window that shows up.
Got it thank you - really appreciate the patience and help. Now is there a way from choosing from the drop down box, if the selection is “hotline” to bring up the message box. the message box is to remind the user to go to the next field over and fill out what “tier” of the hotline the person is on. I believe someone said it would be an “if statement...” so not knowing a lot of VBA where and how would I do that?
Hi. Yes, I mentioned the If action, which is available in a macro, so you don't have to use VBA. From the macro action dropdown, do you see the If action as an option?
Just getting back to work. Let me check... thank you
I am thinking....If primary responsibility equals hotline then run the macro. Alerting them to pick a tier? if that is correct I don’t know how to write it on the macro.
can I set warnings off before the if statement?
Hi. In the macro, you can select all the actions you need and arrange them in any order necessary (based on your logic requirements). So, yes, you can set the warnings off too.
Hi. It was all you! Congratulations! Good luck with your project.
I do have one more question, how can I make this DB for multi users? It’s on a shared drive and under options, advanced it shows default open mode shared, edited record.
