Charles- How would this work with a combobox?
Thanks!
Greg Miller
Charles Parks wrote:
I'm not sure about as the user enter data into a field but if you can settle for the user entering data and then tabbing out of the field you can create the form on a temp view.
In the exit eep of the Store Number have something like Property Table <tvFormTable> 'Close' Drop View tvFormTable Create temp view tvFormTable as select * form FormTable where StoreNumber = .fStoreNumber Property Table <tvFormTable> 'Open' RETURN
In the exit eep of the Store Name you might have something like Property Table <tvFormTable> 'Close' Drop View tvFormTable Create temp view tvFormTable as select * form FormTable where StoreName contains .fStoreName Property Table <tvFormTable> 'Open' RETURN
Otherwise, you might need to have a combobox or listbox instead of the grid.
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Miller Posted At: Wednesday, February 23, 2005 12:55 PM Posted To: RB7-L Conversation: [RBG7-L] - Changing Form Content Subject: [RBG7-L] - Changing Form Content
I am trying to create a form that contains all data pertaining to a particular store. Each store has a number. When I change the store number, I want to update the form to display the new store's number.
Previously, we have always used a menu to select a store, which passes
the store number to a form with "edit using... where...". Unfortunately, many of our techniques date to 2.11 and need serious
updating!
Since there are data navigation controls available now, I am sure that this is possible but I can't figure it out...
Also, the way I want to select the store is with two fields and a grid. As the user enters either the store number or the store name into
either of the fields, the grid will walk to the appropriate loaction
(showing store number, store name, and store state). Has anyone done
something like this?
Thanks!
Greg Miller
