Form to Accept A Name

[twosides]

Hi Folks,
At work I need to create a simple form to allow users to sefl book a training date. Thats easy. There are seveeral dates etc. No probs so far. All I want to do is have a form that displays a blank field (without any other persons name in) that the user type there name in and when they close it it writes it to the table for that date ie Date1Tbl.
I have my form already but it displays the contents of Date1Tbl in the field.

Thanks

 

[John Big Booty]

In your form's On Load event try the following;

 DoCmd.GoToRecord , , acNewRec

This will open the form at a new record and your user can start filling in their details.

Alternately you could set the form's Data Entry property to Yes This means that the user will not be able to see existing records in the form.

 

[twosides]

Thanks for the help, it has given me a pointer in the right direction.
In actual fact I willl have several different fields on the one form to capture a name for any of the 'course dates'

Do I use one table with say 5 fields for 5 training dates or should I have 5 separate tables, one table for each date.

I was going to use some form of IF statement and DCount to ascertain the numbers of people booked on to each day as the room only holds around 20 people.

Cheers

 

[twosides]

Yes I appreciate that. In fact I was looking at the calender and also the code. Wow that is some going. Fair credit to you for that !!