Pop-up message based on drop-down list

[thecrunch]

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]

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]

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]

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]

Row Source: "Yes";"No"

 

[isladogs]

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

 

[theDBguy]

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]

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]

Sounds like should have code in Current event.

Also sounds annoying.

 

[ITguaranteed]

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]

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:

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

 

[thecrunch]

Thanks for your help everyone. Worked like a charm

 

[theDBguy]

Thanks for your help everyone. Worked like a charm

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