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 / February 2006

Tip: Looking for answers? Try searching our database.

listbox selected -> text box question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jayyde - 23 Feb 2006 21:03 GMT
Can someone help me figure out why the following code (problem line ***ed)
is throwing the the error:

"The macro or function set to the BeforeUpdate or ValidationRule property
for this field is preventing the DB from saving the data in this field."

when this control has neither a BeforeUpdate event nor a Validation Rule
either macroed or functioned.  The click event here is literally all the
code there is for this list box.

Private Sub lstAvailable_Click()

   Dim strItem As String

   If (lstAvailable.ItemsSelected.Count = 1) Then

       lstAvailable.SetFocus
       strItem = lstAvailable.Column(1)

       txtAddEditAvailable.SetFocus
       txtAddEditAvailable.Text = strItem

   ElseIf (lstAvailable.ItemsSelected.Count > 1) Then

       lblMultipleAvailable.Visible = True

   End If

End Sub
Jayyde - 23 Feb 2006 21:23 GMT
lol long day...didn't star the line.  It's this one that the debugger
doesn't like:

txtAddEditAvailable.Text = strItem

> Can someone help me figure out why the following code (problem line ***ed)
> is throwing the the error:
[quoted text clipped - 25 lines]
>
> End Sub
 
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.