Text box question

[Guest]

I have a search form that pulls customer orders. We have recently updated one
of the order form's text boxes to a combo box. When the old orders are pulled
they will continue to show information in the old text box. The new orders
will show the same information, but in the combo box. I don't want to show
both of these controls on the form. Can I possibly stack these and make one
or the other visible, depending on which one has the info? If I do this, will
it create a problem when inputing new orders? I hope this makes sense to
somebody out there. If it does, I would appreciate some help with code, etc.
Thanks
Ron

 

[Jeff Boyce]

Ron

I'm confused. I thought you described changing from text to combo box ("...
recently updated ... "). How do you end up with both on the same form?

If you set the Control Source for the new control to be the Control Source
you used for the old/previous control, where's the problem showing up?

 

[Guest]

Hi Jeff. This is a little confusing. This is a database for booking meetings.
The text box was for inputing conference rooms. The combo replaced the text
box for more accurate inputing of the rooms. I added a new table 'Conference
Rooms' to make it easier to add to and edit the rooms. The text box is tied
to my 'Orders' table while the combo is tied to 'Conference Rooms'. When an
older order is viewed, the combo box is blank, on a newer order the text box
is blank. I just don't want both boxes to show up when viewing an order.
Ron

 

[Guest]

Your problem seems to be that they are pulling from TWO different tables. If
this is correct then you have to combine them and use one table and only one
object for data entry/viewing.

 

[Guest]

What this boils down to is: When an order is opened, I need some code that
will make a text box visible when it's dirty and not visible when it's not.
I'm sure this is no big deal, but I just can't get it to work.
Thanks for any help.
Ron

 

[Jeff Boyce]

Ron

Whoa! I'm confused again. If the text box is not visible when it's dirty,
won't your users have no way to edit the value? And won't they be worried
when their data ups and disappears?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Jeff

I have solved my problem. On the forms Current Event, I put a little code in
there to make the old list box visible only if it is "Not Is Null". Since
they won't be editing these old rooms. it shouldn't be a problem. I stacked
this old box on top of the new combo box and it works great. Now whether they
pull up an old order to view it or an order that was created after the combo
box was added, the room can be viewed.
Of course, on going, they will be able to edit the Room.

Thanks for your response.