[RBG7-L] - RE: DB Lookup Listbox

[Javier Valencia]

John: You can try: PROPERTY TABLE your_table_name ‘REFRESH’ After you add data; it should refresh the table. Javier,   Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.  Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ======================================================   -----Original Message----- From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED]On Behalf Of John Docherty Sent: Thursday, March 24, 2005 2:38 PM To: RBG7-L Mailing List Subject: [RBG7-L] - DB Lookup Listbox   I have a DB Lookup Listbox which matches a column in one table (RATES) with a column in another table (SCHED). The form used to edit table SCHED allows values to be entered into the RATES table, via an EEP. I find however that having entered a value in the RATES table, the lookup for that item does not find the matching value unless I close the form and restart it.  I can find the item in the RATES table with a choose from command via another EEP, however the Lookup does not find the match.   Is there anything else I should be doing when the new row is entered in the RATES table to make the match work for the Lookup Listbox ?   Any advice would be appreciated.   Thank you.   Regards   John Docherty     -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.1 - Release Date: 23/03/2005