SEARCH BOX HELP NEEDED

IT WORKS!!!! I took the macro away from the combo box and attached it
directly to the switchboard button and it does work without having to enter a
name twice.

I want to thank you so VERY much for your patience with my many questions
and helping me get my goal accomplished!

Hats off to you!!!! :0)

"bhicks11 via AccessMonster.com" wrote:

I see the problem. You're bound column in the combobox is the OfficerID so
that has to be what you are filtering. Change your filter on to:

[LastName]=[Forms]![LastName_Search]![OfficerID]

Make sure OfficerID is included in the data source (query or table) of that
form.

Bonnie
http://www.dataplus-svc.com

jerseygirl54 wrote:
I think I'm ALMOST there. This is what I have so far:

LastName Search (form) - Record Source - OfficerRoster Query (This Officer
Roster Query is linked to Officer Roster by Officer ID.

On Exit of LastName Search (form)
OpenForm-
Form Name - Students
View - Form
Filter Name -
Where Condition: [LastName]=[Forms]![LastName_Search]![LastName]

On Students Form I have:

Filter: [LastName]=[Forms]![LastName_Search]![LasName]

When I open the LastName Search Form, I can type a name, but when I close
the box (OnExit) I have a popup

"Enter Parameter Value" where I have to re-enter the last name. I do get
the correct Officer form though! (Hurray for THAT!)

I want to be able to type into the original "LastName Search" box without
having to reenter the name into Enter Parameter Value.

Lets just review and make sure we are on the same page. You made a form with
a combobox that you select the officer (SearchLastName). You can open
[quoted text clipped - 21 lines]
I am VERY new and need VERY simple instructions.
Any help you can offer is GREATLY appreciated! :-)

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/200806/1

Great jerseygirl54 - I knew you could do it!

Bonnie(also 54)
http://www.dataplus-svc.com

read by blog at:
http://www.workathomeencouragement.blogspot.com/


jerseygirl54 wrote:
IT WORKS!!!! I took the macro away from the combo box and attached it
directly to the switchboard button and it does work without having to enter a
name twice.

I want to thank you so VERY much for your patience with my many questions
and helping me get my goal accomplished!

Hats off to you!!!! :0)

I see the problem. You're bound column in the combobox is the OfficerID so
that has to be what you are filtering. Change your filter on to:
[quoted text clipped - 37 lines]
I am VERY new and need VERY simple instructions.
Any help you can offer is GREATLY appreciated! :-)

--
Message posted via http://www.accessmonster.com

Hey to both JersyGirl54 and bhicks11

thanks for the detailed work; I needed something very similar and following
both of you I managed to accomplish my goal
SO thanks to both ;o)
--
timH


"bhicks11 via AccessMonster.com" wrote:

Great jerseygirl54 - I knew you could do it!

Bonnie(also 54)
http://www.dataplus-svc.com

read by blog at:
http://www.workathomeencouragement.blogspot.com/


jerseygirl54 wrote:
IT WORKS!!!! I took the macro away from the combo box and attached it
directly to the switchboard button and it does work without having to enter a
name twice.

I want to thank you so VERY much for your patience with my many questions
and helping me get my goal accomplished!

Hats off to you!!!! :0)

I see the problem. You're bound column in the combobox is the OfficerID so
that has to be what you are filtering. Change your filter on to:
[quoted text clipped - 37 lines]
I am VERY new and need VERY simple instructions.
Any help you can offer is GREATLY appreciated! :-)

--
Message posted via http://www.accessmonster.com

Good going Tim - thanks for letting us know!

TimH wrote:
Hey to both JersyGirl54 and bhicks11

thanks for the detailed work; I needed something very similar and following
both of you I managed to accomplish my goal
SO thanks to both ;o)
Great jerseygirl54 - I knew you could do it!

[quoted text clipped - 18 lines]
I am VERY new and need VERY simple instructions.
Any help you can offer is GREATLY appreciated! :-)

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/200807/1