Adding and editing new records to a table

[Guest_imported]

Hi;
I'm new to Access, and am having trouble develping an app for a sporting club that holds monthly events at differing venues. There are 2 main tables; MemberData and VenueData. A 3rd table is called Regis/History and will track the particular participants registered at a specific event (from the VenueData table) and maintain their scoring and ranking history. Periodically the scores are averaged and rankings calculated.

I would like to create a form that contains two combo boxes; one that retrieves the date for a particular event from the VenueData table and another that will retrieve selected member data from the MemberData table. After choosing the particular member, a record would be appended to the Regis/History table containing the event data and the member data. Later, a second form would be used to access these Regis/History records to include the scores for archiving and later calculation.

I am confused as to how to do this; having trouble setting the correct control sources and record sources..... Any ideas?????

Thanx,
Tedr

 

[mymou]

Hi Tedr

Have you tried using the wizards to create the forms?

Once a form is created - you can then use RECORDS | FILTER to find the information you wish to look at (or EDIT | FIND).

Does that help at all?


Stew