K
KR
Hello I have been trying to figure this out for 3 months now. Please help!!!
I have a form and I want to be able to search different fields to find a
specific record. So if I am looking for a specific contact I click on my
contact search and a parameter box opens asking for the contacts name (this
maches on any part of the field which I need) and then I enter a name and my
query pops up with the returning results but from there I want to be able to
select the record I need and have it open up or go to that record I selected
from the query to find that specific record on the form. A combo box will
not work because I have over 1000 records and I don't want to do CTL+F to
find the record or the command button for CTL+F. I found a sample database
on Microsoft office called Issue Database and when you go to the issues form
you can click on the search issues cmd button and then a form pops up and
then you can enter in criteria (however the criteria matches on whole field
and I need and or part of field to match on) but anyway then below in the
footer of the form the results pop up and there is a field in the results
that says edit next to every record and it is blue and underlined and when
you click on it the main issues form opens back up but to that record you
selected and that is something I am looking for. I tried to copy the codes
and change the names to work with mine and couldn't figure out how this blue
underlined edit button was inserted and how it retrieved the record you
select.
So once again I want to be able to search for a record and when my query
returns my results I want to be able to select a specific record from those
results and have it bring me back to the main form to that record I selected.
Here is my table, form, and query names.
Table Name: Contacts
Form Name: ID Card Contacts FM
1st Query Name: ContactSearchAssociation-QRY (when I press a button on my
form a parameter box pops up asking to enter the name of an association, this
match returns all records that match the criteria I enter...Example if I
entered "Smi" it would return records for Smith, Smithson, Smiley, etc)
2nd Query Name:ContactSearchContact-QRY (when I press a button on my form a
parameter box pops up asking to enter the name of the contact, this match
returns all records that match the criteria I enter...Example if I entered
"Smi" it would return records for Smith, Smithson, Smiley, etc)
3rd Query Name: ContactSearchInstitution-QRY (when I press a button on my
form a parameter box pops up asking to enter the name of the institution,
this match returns all records that match the criteria I enter...Example if I
entered "Prin" it would return records for Prince Charles Hospital, Margaret
Princess Hospital, New Prince Ridge, etc)
One more question: is there anyway to make my 3 parameter queries into 1
and have it continue to return records that match on any or part of the
criteria I enter
Thank you so much in advance and I just really hope someone can help me
I have a form and I want to be able to search different fields to find a
specific record. So if I am looking for a specific contact I click on my
contact search and a parameter box opens asking for the contacts name (this
maches on any part of the field which I need) and then I enter a name and my
query pops up with the returning results but from there I want to be able to
select the record I need and have it open up or go to that record I selected
from the query to find that specific record on the form. A combo box will
not work because I have over 1000 records and I don't want to do CTL+F to
find the record or the command button for CTL+F. I found a sample database
on Microsoft office called Issue Database and when you go to the issues form
you can click on the search issues cmd button and then a form pops up and
then you can enter in criteria (however the criteria matches on whole field
and I need and or part of field to match on) but anyway then below in the
footer of the form the results pop up and there is a field in the results
that says edit next to every record and it is blue and underlined and when
you click on it the main issues form opens back up but to that record you
selected and that is something I am looking for. I tried to copy the codes
and change the names to work with mine and couldn't figure out how this blue
underlined edit button was inserted and how it retrieved the record you
select.
So once again I want to be able to search for a record and when my query
returns my results I want to be able to select a specific record from those
results and have it bring me back to the main form to that record I selected.
Here is my table, form, and query names.
Table Name: Contacts
Form Name: ID Card Contacts FM
1st Query Name: ContactSearchAssociation-QRY (when I press a button on my
form a parameter box pops up asking to enter the name of an association, this
match returns all records that match the criteria I enter...Example if I
entered "Smi" it would return records for Smith, Smithson, Smiley, etc)
2nd Query Name:ContactSearchContact-QRY (when I press a button on my form a
parameter box pops up asking to enter the name of the contact, this match
returns all records that match the criteria I enter...Example if I entered
"Smi" it would return records for Smith, Smithson, Smiley, etc)
3rd Query Name: ContactSearchInstitution-QRY (when I press a button on my
form a parameter box pops up asking to enter the name of the institution,
this match returns all records that match the criteria I enter...Example if I
entered "Prin" it would return records for Prince Charles Hospital, Margaret
Princess Hospital, New Prince Ridge, etc)
One more question: is there anyway to make my 3 parameter queries into 1
and have it continue to return records that match on any or part of the
criteria I enter
Thank you so much in advance and I just really hope someone can help me