Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / May 2005

Tip: Looking for answers? Try searching our database.

Form Compatiblity issues

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike-Mike - 02 May 2005 15:06 GMT
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?
TomU - 02 May 2005 15:20 GMT
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

> 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
[quoted text clipped - 7 lines]
> 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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.