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

Tip: Looking for answers? Try searching our database.

button VS drop down

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dan @BCBS - 06 Jul 2007 19:44 GMT
The user clicks a command button, a form opens, the user enters data.
Both forms are from the same table.

Same main form - the user picks a specific value from a drop down, a form
opens, the user enters data.  But when the user goes to the next field on the
main form and enters data a window pops up - "The Data Has Been Changed
another user edited the data....."
What can I change to make this pop up not come up???

Private Sub TR_PROBLEMCODESUFFIX_AfterUpdate()

   Dim stDocName As String
   Dim stLinkCriteria As String
If Me.Dirty Then Me.Dirty = False

   stDocName = "f_Drugs"
   If Me.TR_PROBLEMCODESUFFIX = "CO4" Or Me.TR_PROBLEMCODESUFFIX = "MS3" Then
             
   stLinkCriteria = "[ICNNO]=" & "'" & Me![ICNNO] & "'"
   DoCmd.OpenForm stDocName, , , stLinkCriteria
End If
End Sub

A button on my form opens another form for the user to make comments.
Both forms are from the same table.  I've done this many times, no problem
and the tables gets updated fine.

Now, I have a form pop up when a value is picked from a drop down.  The user
enters the data and closes the form and moves on.  When they try to enter the
next field data on the main form a message pops up " Another user
Dennis - 06 Jul 2007 20:30 GMT
It sounds like you're using two bound forms - both bound to the same table.
When the user clicks the drop-down (asuming the control source is the bound
table), they've made a change to the record. That change needs to be written
back to the database before you can proceed.

> The user clicks a command button, a form opens, the user enters data.
> Both forms are from the same table.
[quoted text clipped - 26 lines]
> enters the data and closes the form and moves on.  When they try to enter the
> next field data on the main form a message pops up " Another user
Dan @BCBS - 09 Jul 2007 13:34 GMT
I would agree with that statement - but my question is how I can/should allow
the update?  I tried using - If Me.Dirty Then Me.Dirty = False - but the
message still comes up.

> It sounds like you're using two bound forms - both bound to the same table.
> When the user clicks the drop-down (asuming the control source is the bound
[quoted text clipped - 31 lines]
> > enters the data and closes the form and moves on.  When they try to enter the
> > next field data on the main form a message pops up " Another user
 
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.