Refresh form search text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I’m having trouble with a switchboard. Everything works fine but, I
have 3 search options on the switchboard. If I choose to use the date search
option and click find it finds my date on another form "Which its supposed to
do" but when I close the search form and the switchboard opens back up it
still has the date I put in the text box to run the search. how would I
refresh the switchboard so when I go back to it there isn’t the data still in
the each boxes? I’m using Me.Visible = False in each search button on the
switchboard so the switchboard just hides when the other form is opened and
when I close the other form I’m using On Unload Forms![Switchboard].Visible =
True. I think its saving what I had because I’m never really closing the
switchboard and that’s my problem! What could I use to clear what’s in my
searches boxes? Thanks!
 
I'm not sure how this will work with switchboards. In the oncurrent event
for the switchboard put Me.searchboxname = Null

Mike
 
I got it to work with Forms![Switchboard].Requery in the switchboards On Open
event... Same thing... Thanks for the help!

--
Newbies need extra loven.........


Mike Revis said:
I'm not sure how this will work with switchboards. In the oncurrent event
for the switchboard put Me.searchboxname = Null

Mike



Chad said:
Hello, I'm having trouble with a switchboard. Everything works fine but, I
have 3 search options on the switchboard. If I choose to use the date
search
option and click find it finds my date on another form "Which its supposed
to
do" but when I close the search form and the switchboard opens back up it
still has the date I put in the text box to run the search. how would I
refresh the switchboard so when I go back to it there isn't the data still
in
the each boxes? I'm using Me.Visible = False in each search button on the
switchboard so the switchboard just hides when the other form is opened
and
when I close the other form I'm using On Unload
Forms![Switchboard].Visible =
True. I think its saving what I had because I'm never really closing the
switchboard and that's my problem! What could I use to clear what's in my
searches boxes? Thanks!
Click to expand...
Click to expand...
 
Back
Top