Forms and New Records ....

[jagstirling]

I have a table with the following Fields;

Staff Name
Time of Day
Rate per Hour

I have 9 records in this table (ie. 9 memberof staff) and want users o
my database to be able to change the Rate per Hour for each person.

When I use the form wizard to create a form to do this it automaticall
prompts me to enter a new record at the end of my form.

Is there any way I can set up a form that will just provide me wit
just the 9 entry boxes for the 9 fields I have ..... and not 'prompt m
to enter a 10th, 'new record' ?

Thanks

 

[Douglas J. Steele]

Open the form in Design mode, and set its Allow Additions property to No.

 

[John Vinson]

Is there any way I can set up a form that will just provide me with
just the 9 entry boxes for the 9 fields I have ..... and not 'prompt me
to enter a 10th, 'new record' ?

Open the Form in design view; view its Properties; and set the "Allow
Additions" property to No.

 

[Ann]

In the properties under the data tab set allow additions to no.

Ann