Access Database Homepage

Question: How to do if...then statment for an access database?

(Posted by: The Phantom on 2010-07-08 10:59:09)

I have a combo box that i linked to an access database which contain names.... i want to make if this username is selected then welcome him

Posted by: Siezer on 2010-07-08, 11:15:50

Since the names are already listed in the combo box you can simply use something like this Private Sub Form_Load() With Combo1 .AddItem "user1 " .AddItem "user2 " .AddItem "user3 " End With End Sub Private Sub Combo1_Click() MsgBox "Welcome " & Combo1.Text & "! " End Sub

Posted by: Billion Dollar Boy on 2010-07-08, 11:20:09

Let's say you have a combo box (Combo0 ) with three names in it Ben Donna Adam If you select your drop down box, then right click and view properties - then go to the events tab and click the "afterupdate " event. Click the build button (...) and this will open up the VBA area. Add this code inside the afterupdate sub: If Me.Combo0.Text = "Donna " Then MsgBox ( "Welcome Donna ") End If This will give a message only if Donna is selected (remember to change the combo0 to the name of your combo box. If you want to send a message to anyone selected, instead of just Donna, use this code instead: MsgBox ( "Welcome " & Combo0.text)