Im using Microsoft Access 2003 and have a form 'frm_contacts' linked to a source table 'tbl_contacts'. My frm_contacts form has a button which when pressed opens a popup form 'frm_hottarget' of some additional fields from the same source table. The frm_hottargets form contains the field 'State' which is the same field in the frm_contacts form.
What i want is to have the State field from the popup frm_hottarget form to change to the value of the State field in the frm_contacts form as soon as the button is pressed. At the moment, the only way i can get the State field from the frm_hottargets form to change to the same value as the frm_contacts form is to close both forms and reopen them, or click the next record button and then back record button from the frm_contacts form.
Any ideas? Cheers
What i want is to have the State field from the popup frm_hottarget form to change to the value of the State field in the frm_contacts form as soon as the button is pressed. At the moment, the only way i can get the State field from the frm_hottargets form to change to the same value as the frm_contacts form is to close both forms and reopen them, or click the next record button and then back record button from the frm_contacts form.
Any ideas? Cheers