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 >> >> >> >
