Can selecting a combo box makes a text box visible again

P

patentinv

Hi,
Is it possible when choosing a combo box to have it make a text box visible,
when in this text boxes properties you've chosen visible=NO. Can an event
procedure or some code be written that will make visible=YES.


Thanks any help with be greatly appreciated
 
O

Ofer

On the after update event of the combo, you can write the code

Me.TextBoxName.Visible = (You condition)

Or
If (You condition) then
Me.TextBoxName.Visible = true
else
Me.TextBoxName.Visible = false
end if
 
P

patentinv

Ofer said:
On the after update event of the combo, you can write the code

Me.TextBoxName.Visible = (You condition)

Or
If (You condition) then
Me.TextBoxName.Visible = true
else
Me.TextBoxName.Visible = false
end if
Click to expand...

I actually need to have the combo box make a total of 6 text boxes visible,
I got the 1 text box working but there are 5 more that I need to do the same
thing to. Is this possible through the combo box that got the 1 visible?
or can it be done in a daisy chain in the text boxes from one to the other?

Thanks-- For your help
 
P

patentinv

I actually need to have the combo box make a total of 6 text boxes visible,
I got the 1 text box working but there are 5 more that I need to do the same
thing to. Is this possible through the combo box that got the 1 visible?
or can it be done in a daisy chain in the text boxes from one to the other?

Thanks-- For your help
 
O

Ofer

Just use the same idea for the rest of the text boxes

Me.TextBoxName1.Visible = (You condition)
Me.TextBoxName2.Visible = (You condition)
Me.TextBoxName3.Visible = (You condition)
Me.TextBoxName4.Visible = (You condition)
Me.TextBoxName5.Visible = (You condition)
Or
If (You condition) then
Me.TextBoxName1.Visible = true
Me.TextBoxName2.Visible = true
Me.TextBoxName3.Visible = true
Me.TextBoxName4.Visible = true
Me.TextBoxName5.Visible = true
Me.TextBoxName6.Visible = true
else
Me.TextBoxName1.Visible = False
Me.TextBoxName2.Visible = False
Me.TextBoxName3.Visible = False
Me.TextBoxName4.Visible = False
Me.TextBoxName5.Visible = False
Me.TextBoxName6.Visible = False

end if
 
P

patentinv

Thanks, gentleman You were allot of help,

I have another question, In my program I have the text boxes that show the
bid set for invisible, Then I have the combo boxes that populate these text
boxes have an on click event procedure that makes the text boxes visible.

Now when I close my program or if i filter to a new record the text boxes go
back to invisible. Is there any way to make my program show these text boxes
visible like they were before I exited the form, when I re-open it to the
same record?

Thanks Chuck
 
P

patentinv

Ofer said:
Just use the same idea for the rest of the text boxes

Me.TextBoxName1.Visible = (You condition)
Me.TextBoxName2.Visible = (You condition)
Me.TextBoxName3.Visible = (You condition)
Me.TextBoxName4.Visible = (You condition)
Me.TextBoxName5.Visible = (You condition)
Or
If (You condition) then
Me.TextBoxName1.Visible = true
Me.TextBoxName2.Visible = true
Me.TextBoxName3.Visible = true
Me.TextBoxName4.Visible = true
Me.TextBoxName5.Visible = true
Me.TextBoxName6.Visible = true
else
Me.TextBoxName1.Visible = False
Me.TextBoxName2.Visible = False
Me.TextBoxName3.Visible = False
Me.TextBoxName4.Visible = False
Me.TextBoxName5.Visible = False
Me.TextBoxName6.Visible = False

end if
Click to expand...

I have another question, In my program I have the text boxes that show the
bid set for invisible, Then I have the combo boxes that populate these text
boxes have an on click event procedure that makes the text boxes visible.

Now when I close my program or if i filter to a new record the text boxes go
back to invisible. Is there any way to make my program show these text boxes
visible like they were before I exited the form, when I re-open it to the
same record?

Thanks Chuck
 
A

ANDRES HIDALGO

patentinv said:
Hi,
Is it possible when choosing a combo box to have it make a text box visible,
when in this text boxes properties you've chosen visible=NO. Can an event
procedure or some code be written that will make visible=YES.


Thanks any help with be greatly appreciated
Click to expand...
 
Top