Update Form

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

Guest

Hello,

I have a form called "frmMain" and on that form I have four list boxes. The
table for these list boxes are tblSurveyor.

If one of my users are entering data and the surveyor is not in the list.
The data entry person can click a button and a form called frmSurveyor opens
up and the data entry person can input the surveryors name in the frmSurveyor
and exit the frmSurveyor. The problem is that the frnMain is not updated.
to reflect the new data entry.

How do I get the frm Main to refresh?

Thanks,
 
If your frmMain is always open when you enter/change a surveyor record, you
can add a line of code to frmSurveyor (afterupdate)

Forms!frmMain.Mylisboxname.requery

If frmMain is sometimes open and sometimes not open, you'll want to add
something a little more complicated which will first check to see if frmMain
is open. There is an example of how to do that at
http://www.mvps.org/access/forms/frm0002.htm

Linda


Linda
 
Back
Top