Hi Mark,

I am trying out your method and like it very much. I am having a problem when I delete a record. On the page is two drop down list boxes where I show the company and the contact for that record. When I delete a record the contact list box becomes empty when it should contain a name. If I tab around the screen two times it shows up. All other times this works as expected. The list boxes are both bound to the view.

I am using the following code to delete a record. iKey is the PK for that record.

* Delete this Record
DELETE FOR JobData.Jobid = ThisForm.iKey IN "JobData"
* Send the update
IF NOT TableUpdate( 0, .F., "JobData" )
  * The update failed
  TableRevert(.F., "JobData")
ENDIF
* Blank the view
ThisForm.iKey = -1
REQUERY("JobView")
ThisForm.Refresh()

Should I delete the record in another way?

Thanks so much for your help.