Create a search records option

[paulsimo]

Hi, I hope somebody can help me with this seemingly simple problem.

I currently have a database that keeps a record of competitors details and the results of their performance in a race.
I would like to have an option that any competitor can enter their race number into a form. The form would simply have a text box for them to enter their race number details, and an enter or search button. I would then like it to display this competitors particular details and race results.
The form needs to look simple and easy to use as there will be a large number of people, with the opportunity to use the search facility.
I expect there could be as many as 1000 competitors in the database.

Hope you can help me out.

 

[ajetrumpet]

Hi, I hope somebody can help me with this seemingly simple problem.

I hope somebody can too.

I would like to have an option that any competitor can enter their race number into a form. The form would simply have a text box for them to enter their race number details, and an enter or search button.

You have just described how to do this task.

I would then like it to display this competitors particular details and race results.

This might be the only part of this post that requires a response, as it might be difficult. What do you want to know about this? How to get the form to display the results? If that is what you want, I would just use a parameter query as the form's recordsource, and write some openform code on the search button's click event.