Pop-up message based on drop-down list (1 Viewer)

thecrunch · Jun 21, 2019

Hello,

I have a 'check in/check out' split form for our company library. This form has a 'loan allowed' field with a Yes/No selection from a drop down list.

If a user selects an asset to check out with the loan allowed field = "No" , i would like to implement a pop-up message that states "warning! no loans allowed". With an ok only button.

I have attempted to create this with an if statement in the after update event of the loan allowed field. However, i have not been successful.

Any help is appreciated! Thanks

theDBguy · Jun 21, 2019

Hi. Welcome to the forum. Just curious first, what happens after the user clicks OK on the popup message? Are you expecting to cancel the selection then?

thecrunch · Jun 21, 2019

Thank you for responding. I would like the pop-up message to close once the okay button is clicked. The item selection does not need to be cancelled.

theDBguy · Jun 21, 2019

thecrunch said:
Thank you for responding. I would like the pop-up message to close once the okay button is clicked. The item selection does not need to be cancelled.

Okay, let’s see what you have in the Row Source of your dropdown.

thecrunch · Jun 21, 2019

Row Source: "Yes";"No"

isladogs · Jun 21, 2019

Please post the code you used unsuccessfully.
What happened when you used it? If an error, what was the error number/description?

theDBguy · Jun 21, 2019

thecrunch said:
Row Source: "Yes";"No"

Hmm, not what I was expecting. So, let's back up a bit. You said the user "selects an asset," how exactly do they do this?

thecrunch · Jun 23, 2019

Hi theDBguy,

Apologies for not being clear in the original post.

It is a split form, where the user can use the datasheet portion of the form to locate a record, and use the form portion to view or edit the record. Once a record is located and selected, I would like an okay only pop-up box to occur if the selected record has a ‘No’ within the loan allowed field. The loan allowed field has been set up as a dropdown box with the row source "Yes";"No".

The popup box is simply a warning to the user, who may then click ‘okay’ as an acknowledgement of the warning. The pop-up box will close once ‘okay’ is clicked and the user may continue to edit the selected record or select a new one.

June7 · Jun 23, 2019

Sounds like should have code in Current event.

Also sounds annoying.

ITguaranteed · Jun 24, 2019

Call me crazy, but wouldn't it be better to have the list only show items the users can check out?
Or if it isn't a list then disable the check out button.

theDBguy · Jun 24, 2019

thecrunch said:
Hi theDBguy,

Apologies for not being clear in the original post.

It is a split form, where the user can use the datasheet portion of the form to locate a record, and use the form portion to view or edit the record. Once a record is located and selected, I would like an okay only pop-up box to occur if the selected record has a ‘No’ within the loan allowed field. The loan allowed field has been set up as a dropdown box with the row source "Yes";"No".

The popup box is simply a warning to the user, who may then click ‘okay’ as an acknowledgement of the warning. The pop-up box will close once ‘okay’ is clicked and the user may continue to edit the selected record or select a new one.

Hi. Thank you for the additional information. As June said, you'll need some code in the form's Current event. For example:

Code:

If Me.DropdownName = "No" Then
    MsgBox "Your message here...", vbInformation, "Warning!"
End If

thecrunch · Jun 24, 2019

Thanks for your help everyone. Worked like a charm

theDBguy · Jun 25, 2019

thecrunch said:
Thanks for your help everyone. Worked like a charm

Hi. Glad to hear you got it to work. Good luck with your project.

Pop-up message based on drop-down list (1 Viewer)

thecrunch

New member

theDBguy

I’m here to help

thecrunch

New member

theDBguy

I’m here to help

thecrunch

New member

isladogs

MVP / VIP

theDBguy

I’m here to help

thecrunch

New member

June7

AWF VIP

ITguaranteed

New member

theDBguy

I’m here to help

thecrunch

New member

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread