UtterAccess.com
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
> Search Box On Non-editable Form, Access 2016    
 
   
frethack
post Apr 1 2020, 12:00 PM
Post#1



Posts: 14
Joined: 5-February 20



Hello All!

I have a non-editable main form (the query on which it is based is non-editable) that I would like to add an unbound control to be used as a search tool. Ive tried adding the text box directly to the main form, and placed it in as a subform, but in both instances the control/subform is also uneditable.

Before I go back to the main form datasource and make it editable, which involves altering controls on the form as well, I though I would see if there was a simpler solution to my problem.

My problem could also just be that its a bad idea to base a form on an uneditable query.

Thank you for your help!
Go to the top of the page
 
DanielPineault
post Apr 1 2020, 12:17 PM
Post#2


UtterAccess VIP
Posts: 7,374
Joined: 30-June 11



Make a main for which is editable, then insert you existing form as being uneditable. Now create your search box within the main, editable, form.

--------------------
Daniel Pineault (2010-2020 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
projecttoday
post Apr 1 2020, 12:49 PM
Post#3


UtterAccess VIP
Posts: 12,375
Joined: 10-February 04
From: South Charleston, WV


You can also put the search box in the header of the form.

--------------------
Robert Crouser
Go to the top of the page
 
frethack
post Apr 1 2020, 01:29 PM
Post#4



Posts: 14
Joined: 5-February 20



Thank you both! Not sure where my brain was. Gonna go with the subform idea.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    4th July 2020 - 12:19 AM