Form Compatiblity issues

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two forms that I need to work closely together. The first form is the
search application form. You search through application records based upon
an applicants full name. If you search for a name not found in the database
your asked if you would like to add applicant. Then you are taken to the add
applicant form where you input the new record. I want to be able to add the
new record then go back to the original search applicant form. The problem
is that when I go back to the search applicant form the new record I input
doesn't show up. I have to close the search applicant form and reopen it and
then the new record is present. I've tried Me.Refresh after update but it
didn't work. Any suggestions how I can get the new record to appear in the
search form once I add the applicant from the add applicant form?
 
Try using using the Requery command instead of Refresh. I assume you are
issuing this command in the second form's AfterUpdate event code. If so,
using Me.Requery will affect the second form, not the first. So you need to
reference the first form with something like:

Forms!frmForm1.Requery

TomU
 
Back
Top