CLOSE all USE bill in 0 USE contact in 0 lcField = alltrim(thisform.text1.value) replace in contact ; val with val(lookup(bill.bill_value,contact.&lcField,bill.&lcField)) ; for not eof('bill')