I just tried that and it sort of works. The problem is the drop down does not work like the combo box when the user clicks on the db label.
Dan From: [email protected] Sent: Wednesday, July 11, 2012 11:05 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: db lookup combo box issue Dan: Have you ever tried a "fake" combo box? Locate the customer name as a DBLabel (or a DBEdit with read-only). To the right of the field, locate a little button/icon with a look that would mimic the down arrow of a combo or I usually put the "search" type of magnifying glass. That button would bring up a choose list of active clients (or if you don't like the choose, design a tiny form that looks like a combo box). I usually hide the "customer id" field on the form and use the property .. textvalue command to put the chosen record in that field and update the lookup variables to display the name. Karen In a message dated 7/11/2012 1:00:19 PM Central Daylight Time, [email protected] writes: -----Original Message----- From: "Dan Goldberg" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 11 Jul 2012 10:03:25 -0700 Subject: [RBASE-L] - Re: db lookup combo box issue I was thinking of that but I want to keep the users from picking inactive dealers. If they do not see it then they cannot select it. Dan
