Eurico, So the lookup form (modal) is the one which updates the record. In that case you need to:
1. Make sure that the record is UNLOCKED in the calling form before you call the Modal Form or you will get update conflicts 2. When the modal form has been called and the updated record written away then after the do form <lookup_form> you need to use either of the methods below: a) Issue a refresh of any control that will have access to the updated record - note that sometimes a simple Thisform.Refresh() will NOT work and you will need to issue individual refresh commands for each control in a user defined form method e.g MyRefresh(). Or b) issue a goto <another_record_Number> followed by goto <the_changed_record_Number> to pull back original records new data then issue a Thisform.Refresh(). If the data is in a browse then look at the "set refresh" setting which should refresh the data automatically as required but in most cases a Thisform.Refresh will suffice. Obviously you can use the seek() command as opposed to the goto approach Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eurico Chagas Filho Sent: 11 June 2007 13:40 To: 'ProFox Email List' Subject: How to update a table ? Hi Sorry, my bad. The table, table1, resides in the form's environment and is not updated, it's just for lookup. But, in another form table1 is updated and I need to access the fresh data in table1. The only way is to issue an USE than USE AGAIN or what ? TIA, E. No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.8.13/843 - Release Date: 6/10/2007 1:39 PM [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
