data entry form

[gbmarlysis]

hi,
i want to create a form where i can enter in
1- an athletes name (then his details come up eg dob)
then
2- enter in the race he ran in (if its a new race then plots in table if its a race entered already then the other details come up eg distance date)
then
3) enter in the athletes position in the race his time etc

and then at the bottom of the form as i put in their name all the races and positions they have run (so i know what needs to be entered)

i currently have three tables
1-athletes


2-races
3-race details

Can any one help me with this form please...is it possible..people say anything is possible in access..
many thanks lb

[June7]

A form to enter athlete and their race results could be a form/subform arrangement. Would have to enter the races by another form. The race would have to already be in table before could enter athlete and results. If you want to enter the races 'on-the-fly', will need code to open form for entering the race. Then if you have a combobox for selecting race on the other form/subform, might also need code to refresh the combobox to show the new entry. As I said, the more user-friendly, the more code

Building forms is basic Access functionality and Help has guidelines to get you started.