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 / SQL Server / ADP / February 2008

Tip: Looking for answers? Try searching our database.

Clearing controls problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RJ - 25 Feb 2008 17:30 GMT
I have an inquiry screen with multiple unbound selection criteria controls in
the form header section.  The usual stuff - nothing exotic.  Once the user
clicks on the Search button, the record source is set to a Exec the SP
passing the variables from the controls.  There is also a "refresh" button
that clears (nulls) all the selection controls described above.

If the sp found matching records, they are displayed, and if the user clicks
on the Refresh button, all the controls are cleared and ready for the next
search. As expected.

However if the SP found no records, and the user clicks on refresh, the
controls are not VISIBLY cleared!  The strange part is  the controls are
blanked out  as you tab through them.  I tried a repaint but that proved
useless.  Through debug.print I can see that the routine is being executed
and the control values are being cleared however the old value remain visible
in the form!  I have several other forms that are similar in nature but the
one descibed is the only one having the clearing problem.

Any ideas,
Your help is much appreciated!

RJ
RJ - 26 Feb 2008 18:36 GMT
If anyone has the same problem.....

As soon as the sp returned an empty recordset, I set the the RecordSource
back to an emptystring and the controls worked (cleared) as normal.
 
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.