List box

  • Thread starter Thread starter Jacob
  • Start date Start date
J

Jacob

I am trying to make text boxes appear only if a certain selection in a
list box is made. For instance, I have a list box I will call list1 and a
text box I will call box. On the Box properties, I have set the visible
property to no. When I select a certain option in list1, I want that
property to change to visible = true. How do I do this?

--



Jacob A. Servay
InterMed Inc.
13351 Progress Blvd.
Alachua, Fl 32615
1-800-768-8622 ext 308
 
Dan, I have this in the equation, but it does not seem to work. Is there
something going wrong here I am not aware of? He is how I have it in the
After update....


If Me.[Equipment type] = Probe Then
Me.Pdes.Visible = True
Else: Me.Pdes.Visible = False
End If
 
Hi,
You have to enclose strings in quotes
If Me.[Equipment type] = "Probe" Then

--
HTH
Dan Artuso, Access MVP


Jacob said:
Dan, I have this in the equation, but it does not seem to work. Is there
something going wrong here I am not aware of? He is how I have it in the
After update....


If Me.[Equipment type] = Probe Then
Me.Pdes.Visible = True
Else: Me.Pdes.Visible = False
End If
Click to expand...
 
Thanks Dan, that did it. I am new to the VBA side of access, but watching
these news groups and leaning more each day.



Dan Artuso said:
Hi,
You have to enclose strings in quotes
If Me.[Equipment type] = "Probe" Then

--
HTH
Dan Artuso, Access MVP


Dan, I have this in the equation, but it does not seem to work. Is there
something going wrong here I am not aware of? He is how I have it in the
After update....


If Me.[Equipment type] = Probe Then
Me.Pdes.Visible = True
Else: Me.Pdes.Visible = False
End If



Dan Artuso said:
Hi,

IN the AfterUpdate event of List1:

If Me.List1 = whatever Then
Me.Box.Visible = True
Else
Me.Box.Visible = False
End If



--
HTH
Dan Artuso, Access MVP


I am trying to make text boxes appear only if a certain
Click to expand...
selection in
a
list box is made. For instance, I have a list box I will call list1
Click to expand...
and
a
text box I will call box. On the Box properties, I have set the visible
property to no. When I select a certain option in list1, I want that
property to change to visible = true. How do I do this?

--



Jacob A. Servay
InterMed Inc.
13351 Progress Blvd.
Alachua, Fl 32615
1-800-768-8622 ext 308
Click to expand...
Click to expand...
Click to expand...
 
Re: How To Delete a record from a listbox?

Hi Guys, I had a problem here....
I have created a listbox in Microsoft Access and i create a delete button too but how do i delete the record in the listbox by making use of the delete button that i had created?


Reply mi if u can help mi solve it thx..
(e-mail address removed)
 
Back
Top