You just setup a normal variable lookup combobox and in the on click eep
you could have something like Property Table <tvFormTable> 'Close' Drop View tvFormTable Create temp view tvFormTable as select * form FormTable where <ReturnColumn> = .f<ReturnColumn> Property Table <tvFormTable> 'Open' return -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Miller Posted At: Wednesday, February 23, 2005 2:31 PM Posted To: RB7-L Conversation: [RBG7-L] - RE: Changing Form Content Subject: [RBG7-L] - RE: Changing Form Content 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 >
