arcanedevice
10-21-2008, 07:03 PM
Hi
I'm a complete newbie at Access, but have managed to work out most things by using my Excel / Word experience. However, I'm struggling to find out how I can create a form to 'search' a table for data and return the record in another form.
As an example, what I have set up is a form 'Search' that has one (unbound) text box 'Organisation' that the user will enter some text into, and then click on a 'Search' command button. This click will prompt a search of the 'Organisation' field within my table 'Organisations' to find matching record/s for that text.
If a match is found, then the full record is returned in another form 'Results' (or a 'No Matching Records' message is received).
While I have set the forms up, I'd really appreciate any help that people can offer on setting up the code etc to make it happen, because I need to set about 5 of these searches up (and then I've got to make them more detailed and/or searches, so the practice will be great!).
I'm a complete newbie at Access, but have managed to work out most things by using my Excel / Word experience. However, I'm struggling to find out how I can create a form to 'search' a table for data and return the record in another form.
As an example, what I have set up is a form 'Search' that has one (unbound) text box 'Organisation' that the user will enter some text into, and then click on a 'Search' command button. This click will prompt a search of the 'Organisation' field within my table 'Organisations' to find matching record/s for that text.
If a match is found, then the full record is returned in another form 'Results' (or a 'No Matching Records' message is received).
While I have set the forms up, I'd really appreciate any help that people can offer on setting up the code etc to make it happen, because I need to set about 5 of these searches up (and then I've got to make them more detailed and/or searches, so the practice will be great!).