Bernie,
You can do the same thing with enter mode. I use this technique in all of my applications. User types in the zip code. On Exit EEP I perform a GetProperty to save the zip code into a variable. The next field on the form is the city. In the city field I use the popup menu to display the list of cities that correspond to zip code that was entered. It is simple and it works great. John From: [email protected] [mailto:[email protected]] On Behalf Of Bernard Lis Sent: Friday, August 21, 2009 2:40 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Property refresh problem v7.6 I did use SAVEROW but it still didn't work, But my work around was to insert a row with just the customer no. and then use the same form in edit mode. ----- Original Message ----- From: [email protected] To: RBASE-L Mailing List <mailto:[email protected]> Sent: Friday, August 21, 2009 2:27 PM Subject: [RBASE-L] - RE: Property refresh problem v7.6 Bernie, If you're in ENTER mode, you're not updating the table because the row isn't there yet (unless you're issuing a SAVEROW prior to looking up your values.) So refreshing the table is just refreshing with blank data. Try this in your on exit eep from the zip code field, after looking up the values PROPERTY cityfieldcomponentid TEXTVALUE .vcity PROPERTY statefieldcomponentid TEXTVALUE .vstate RECALC VARIABLES Dawn Hast Office - (828) 646-2669 Cell - (828) 246-8543 [email protected] wrote on 08/21/2009 02:17:54 PM: > Hi John, > Thanks for your reply. > I key in a zip code, then look up the city and state in another table, then > update the customer table with those 2 vars, then I want to refresh the form > so that the city and state appear. > Could it be that refresh doesn't work in enter mode? > > Bernie Lis > > ----- Original Message ----- > From: "John Engwer" <[email protected]> > To: "RBASE-L Mailing List" <[email protected]> > Sent: Friday, August 21, 2009 2:02 PM > Subject: [RBASE-L] - RE: Property refresh problem v7.6 > > > > Hi Bernie, > > > > What are you trying to do with the refresh? If you are using the form in > > enter mode the data that you just entered should be on the screen until > > you > > exit. The refresh will just bring up a blank record in that case. > > > > John > > > > > > > > -----Original Message----- > > From: [email protected] [mailto:[email protected]] On Behalf Of Bernard > > Lis > > Sent: Friday, August 21, 2009 1:45 PM > > To: RBASE-L Mailing List > > Subject: [RBASE-L] - Property refresh problem v7.6 > > > > Hi All, > > I used property table customer 'refresh' > > Then all the col's disappeared from the form. > > There was only 1 row in the table and I am in Enter Using mode, attempting > > to add a second row. > > I did edit * from customer both before and after the refresh, there was > > not > > a third row added and the second row was there with the new data. > > What could I be doing wrong all of a sudden. > > > > Bernie Lis > > > > > > > > DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Evergreen Packaging is not responsible for any changes made to this message and / or any attachments after sending by Evergreen Packaging. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment.
