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 / Forms / July 2007

Tip: Looking for answers? Try searching our database.

Losing data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bohon79 - 04 Jul 2007 19:54 GMT
Need some help.  I have two forms that are virtually the same with one form
that has a little more data then the other.  The question that I have is that
on one form it will allow me to add new personnel when they come into the
unit.  Then I click a button to add them to the database and into another
form that will allow me to update there information as time goes by.  The
problem that I am running into that one of the fields on the first form has a
drop down where I either put in a yes or no.  Same thing on the other form.
When I click on the button to send them to the database, I go into the form
that I will be able to update there information and the data that was suppose
to be in the field on this second form is gone.
John W. Vinson - 04 Jul 2007 21:08 GMT
>Need some help.  I have two forms that are virtually the same with one form
>that has a little more data then the other.  

The FORMS don't contain any data. They're just windows. The data exists in
tables, and only in the tables!

What are the forms' recordsources? Are they queries on the same table?

>The question that I have is that
>on one form it will allow me to add new personnel when they come into the
[quoted text clipped - 5 lines]
>that I will be able to update there information and the data that was suppose
>to be in the field on this second form is gone.

What's the code on the button? Possibly the record is still not written to the
table.

            John W. Vinson [MVP]
 
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



©2009 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.