I do exactly as Albert says. I would display the vendor name in a non-editable variable box, and then locate a little button to the right of it to select the active vendors. I sometimes put just a bmp of a little down arrow to duplicate the look of a combo box Karen -----Original Message----- From: Albert Berry <[email protected]> To: rbase-l <[email protected]> Sent: Wed, Sep 11, 2019 7:05 pm Subject: Re: [RBASE-L] - db combo lookup box not showing value
Perhaps displaying the vendor in a text box and having a double click drop down EEP on the field that would only see the active vendors?Albert On Sep 11, 2019, at 4:05 PM, Dan Goldberg <[email protected]> wrote: I have a part form with a db combo lookup box. I want to use the where clause to only select active vendors, which works fine. But if I want to look at a part that has an inactive vendor the field shows blank. How can I show the value but still only let the user see/select the actives? <image002.jpg> Dan Goldberg -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0011EB52B9D%40EXCHANGE10. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/03CA3D8E-8286-4A9A-AD31-C6C071EE369D%40albertberry.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/418222923.6419669.1568295438601%40mail.yahoo.com.
