J
jerseygirl54
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)
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 said: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
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.
[quoted text clipped - 21 lines]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 openI am VERY new and need VERY simple instructions.
Any help you can offer is GREATLY appreciated!