SEARCH BOX HELP NEEDED

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
SearchLastName from the switchboard.

SearchLastName opens the Class form (or whatever form has the data source
that you want to see - of course this form must have the ID that you selected
in SearchLastName so you can filter it) and sets you on that particular
officer's record/info.

All forms have a filter property. You right click on the black button at the
upper left hand corner of your form and then select Properties, from there
you select the Data tab and you will see your data source and the next line
will be filter. That's were you put the filter criteria.

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


jerseygirl54 wrote:
I've been playing with this and found that the "Filter" line is on the
"Students" form, but I still can't get it to work.

Okay, don't close the LastNameSearch form when you open the main form so that
it can be referred to.
[quoted text clipped - 24 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

(Answer to Paragraph 1)

Not from the Switchboard. All I did was create an Unbound Combo Box
"SearchLastName" that has a query "Officer Roster Query". I can select a
name and that's it. I've placed an "On Exit" , "OpenForm" which opens the
"Students", but it only opens to the first officer by Serial number
(OfficerID), no matter which officer is chosen in the combo box.

(Answer to Paragraph 2)

Yes, it opens the Students form, but only to the first officer on the roster
sorted (Asending) by OfficerID. In other words, the Officer with the lowest
ID number.

I have found the filter line on the "Students' form, but am unable to find
any filter on the SearchLastName form. I will look again. :-)

"bhicks11 via AccessMonster.com" wrote:

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
SearchLastName from the switchboard.

SearchLastName opens the Class form (or whatever form has the data source
that you want to see - of course this form must have the ID that you selected
in SearchLastName so you can filter it) and sets you on that particular
officer's record/info.

All forms have a filter property. You right click on the black button at the
upper left hand corner of your form and then select Properties, from there
you select the Data tab and you will see your data source and the next line
will be filter. That's were you put the filter criteria.

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


jerseygirl54 wrote:
I've been playing with this and found that the "Filter" line is on the
"Students" form, but I still can't get it to work.

Okay, don't close the LastNameSearch form when you open the main form so that
it can be referred to.
[quoted text clipped - 24 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

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.

"bhicks11 via AccessMonster.com" wrote:

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
SearchLastName from the switchboard.

SearchLastName opens the Class form (or whatever form has the data source
that you want to see - of course this form must have the ID that you selected
in SearchLastName so you can filter it) and sets you on that particular
officer's record/info.

All forms have a filter property. You right click on the black button at the
upper left hand corner of your form and then select Properties, from there
you select the Data tab and you will see your data source and the next line
will be filter. That's were you put the filter criteria.

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


jerseygirl54 wrote:
I've been playing with this and found that the "Filter" line is on the
"Students" form, but I still can't get it to work.

Okay, don't close the LastNameSearch form when you open the main form so that
it can be referred to.
[quoted text clipped - 24 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

Your making progress. What do you have in the row source of your combobox?
I think that's why you are having a popup.

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

jerseygirl54 wrote:
(Answer to Paragraph 1)

Not from the Switchboard. All I did was create an Unbound Combo Box
"SearchLastName" that has a query "Officer Roster Query". I can select a
name and that's it. I've placed an "On Exit" , "OpenForm" which opens the
"Students", but it only opens to the first officer by Serial number
(OfficerID), no matter which officer is chosen in the combo box.

(Answer to Paragraph 2)

Yes, it opens the Students form, but only to the first officer on the roster
sorted (Asending) by OfficerID. In other words, the Officer with the lowest
ID number.

I have found the filter line on the "Students' form, but am unable to find
any filter on the SearchLastName form. I will look again. :-)

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
SearchLastName from the switchboard.

SearchLastName opens the Class form (or whatever form has the data source
that you want to see - of course this form must have the ID that you selected
[quoted text clipped - 17 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

Row Source is "OfficerRoster Query

"bhicks11 via AccessMonster.com" wrote:

Your making progress. What do you have in the row source of your combobox?
I think that's why you are having a popup.

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

jerseygirl54 wrote:
(Answer to Paragraph 1)

Not from the Switchboard. All I did was create an Unbound Combo Box
"SearchLastName" that has a query "Officer Roster Query". I can select a
name and that's it. I've placed an "On Exit" , "OpenForm" which opens the
"Students", but it only opens to the first officer by Serial number
(OfficerID), no matter which officer is chosen in the combo box.

(Answer to Paragraph 2)

Yes, it opens the Students form, but only to the first officer on the roster
sorted (Asending) by OfficerID. In other words, the Officer with the lowest
ID number.

I have found the filter line on the "Students' form, but am unable to find
any filter on the SearchLastName form. I will look again. :-)

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
SearchLastName from the switchboard.

SearchLastName opens the Class form (or whatever form has the data source
that you want to see - of course this form must have the ID that you selected
[quoted text clipped - 17 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

Make sure it is a combobox, the row type should be Table/Query and for the
row source click on the ... on that line to create the query. When you
create the query and exit it, the query SQL will be placed on the Row Source
line.

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

jerseygirl54 wrote:
Row Source is "OfficerRoster Query

Your making progress. What do you have in the row source of your combobox?
I think that's why you are having a popup.
[quoted text clipped - 28 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

Yes, I checked and it is a combobox. It is a Table/Query and for the row
source, I clicked on the ... and have Officer Roster as the table choice with
three choices picked: OfficerID, LastName, FirstName. I closed the query and
what shows on the Row Source line is "OfficerRoster Query" (nothing else)

"bhicks11 via AccessMonster.com" wrote:

Make sure it is a combobox, the row type should be Table/Query and for the
row source click on the ... on that line to create the query. When you
create the query and exit it, the query SQL will be placed on the Row Source
line.

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

jerseygirl54 wrote:
Row Source is "OfficerRoster Query

Your making progress. What do you have in the row source of your combobox?
I think that's why you are having a popup.
[quoted text clipped - 28 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

Okay, check what is in the criteria of that query. I'm trying to figure out
what you are having a parameter popup box.

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

jerseygirl54 wrote:
Yes, I checked and it is a combobox. It is a Table/Query and for the row
source, I clicked on the ... and have Officer Roster as the table choice with
three choices picked: OfficerID, LastName, FirstName. I closed the query and
what shows on the Row Source line is "OfficerRoster Query" (nothing else)

Make sure it is a combobox, the row type should be Table/Query and for the
row source click on the ... on that line to create the query. When you
[quoted text clipped - 11 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

There isn't anything in any of the three columns :

OfficerID LastName FirstName
OfficerRoster OfficerRoster OfficerRoster
Assending

"bhicks11 via AccessMonster.com" wrote:

Okay, check what is in the criteria of that query. I'm trying to figure out
what you are having a parameter popup box.

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

jerseygirl54 wrote:
Yes, I checked and it is a combobox. It is a Table/Query and for the row
source, I clicked on the ... and have Officer Roster as the table choice with
three choices picked: OfficerID, LastName, FirstName. I closed the query and
what shows on the Row Source line is "OfficerRoster Query" (nothing else)

Make sure it is a combobox, the row type should be Table/Query and for the
row source click on the ... on that line to create the query. When you
[quoted text clipped - 11 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

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