Combo Box Help

[rnickels]

Can someone please help me?

I have a combo box on a form that the user can select a player name.
Under the combo box I have a label called "Show me information about selected Player: that once clicked takes the user to another form which has all information about the player that was previously selected in the combo box.

Everything works fine UNLESS the user forgets to select a playername from the combo box and clicks on the label anyway. Obviously no player name was selected so a blank form opens which is a problem!

How can I ensure that a player name is selected and prevent the user from clicking on the label below without having previously selecting from the combo box?

If anyone can please help I would appreciate it so much.

Rob

 

[alastair69]

you could use an if statement something like.

on load
if me.PlayerName (Your Comb box name) = "null" then
me.Information (Your Command Button Name).visable=False else
me.information.visable = True
end if
end sub

if you can post the DB i will look at it for you.

Alastair

 

[boblarson]

Duplicate posting - the answer is given in the other location