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

Tip: Looking for answers? Try searching our database.

Combo Box look up problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
linda - 07 Feb 2006 18:23 GMT
I'm in the process of creating a form with lookup fields.  The problem
I'm having is this:  When you enter data into one of the look up
fields, the data says there.  I need it to clear the field after you
hit Enter or Tab.  How do I do this??  This is what is displayed 'after
update':

Private Sub Combo11_AfterUpdate()
   ' Find the record that matches the control.
   Dim rs As Object

   Set rs = Me.Recordset.Clone
   rs.FindFirst "[InvoiceNumber] = " & Str(Me![Combo11])
   Me.Bookmark = rs.Bookmark
End Sub

What's missing?
inkman04 - 07 Feb 2006 19:13 GMT
Hello Linda,

No problem. Enter the following line after
Me.Bookmark = rs.Bookmark

Combo11.value = null

Just that simple.

And, if you want to go to another field on the form
just add the next line:

DoCmd.GoToControl "ControlName"

Have a nice day.

Regards
linda - 09 Feb 2006 18:37 GMT
Thanks, I had a feeling it would be something simple like that!
 
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.