X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Access 365 How Do I Clear Out The Values In The Search Command After Openquery?, Any Version    
post Aug 27 2019, 05:45 PM

Posts: 9
Joined: 21-August 19


So, I created a read only search form for anyone to pull several records of any fields. The Search Command button has the OpenQuery macro however I am trying to add a new action called Requery after the OpenQuery to clear out the previous search in the form (not datasheet)....it asked for the Control Name....I am stumped at that point!

Thank you!
Attached File(s)
Attached File  add_a_value_in_search.JPG ( 18.88K )Number of downloads: 0
Attached File  Opens_ups_READ_ONLY_datasearch_after_search.JPG ( 24.3K )Number of downloads: 0
Attached File  Macro.JPG ( 18.46K )Number of downloads: 0
Attached File  Control.JPG ( 22.66K )Number of downloads: 0
Go to the top of the page
post Aug 27 2019, 06:03 PM

Posts: 968
Joined: 25-January 16

Requery would not clear controls.

I only use VBA so to clear controls I would use:

Me.controlname = Null

In macro I think you would use SetValue action.

Click Show All Actions on Macro Tools Design tab.

This post has been edited by June7: Aug 27 2019, 06:08 PM

Attachments Manager is below the edit post window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG! http://www.cpearson.com/Excel/DebuggingVBA.aspx
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    19th November 2019 - 11:14 AM