| Computers Forum Index » Computer - Databases - MS Access » Blank fields required on a search form on form load... |
|
Page 1 of 1 |
|
| Author |
Message |
| Arlette... |
 Posted: Sun Nov 01, 2009 12:52 pm |
|
|
|
Guest
|
I have a search screen in MS Access 2003, with a unbound text box to
put in the parameter to search. I need to have all the text boxes in
the columnar display blank on form load. How do it do this? |
|
|
| Back to top |
|
|
|
| Roger... |
| Posted: Sun Nov 01, 2009 1:46 pm |
|
|
|
Guest
|
On Nov 1, 5:52 am, Arlette <arlette.deso... at (no spam) gmail.com> wrote:
Quote: I have a search screen in MS Access 2003, with a unbound text box to
put in the parameter to search. I need to have all the text boxes in
the columnar display blank on form load. How do it do this?
so you have a search box and a continous form
and if there's nothing in the search box, you want the form to show
nothing ?
set the form's recordsource to
select * from yourTable where 1 = 2
and once you entered something in the search box, set the recordsource
to
"select * from yourTable where somefield = '" & searchbox & "'" |
|
|
| Back to top |
|
|
|
| Arlette... |
| Posted: Sun Nov 01, 2009 3:21 pm |
|
|
|
Guest
|
My result for the search is working through a subform. THere is no
code as such to populate the form. So how do i do it in this case? |
|
|
| Back to top |
|
|
|
|
