Forms & comand button

[Guest]

1. How do I limit a form to submit only new records, old record must not be
accessible.
2. How do I get a command button to do 2 things the wizzard only alow me to
pick one. I want on clicking the button (a) run a update querie and (b) add
new record.
Thanks

 

[Rick Gittins]

1) Take the record navigation off of the bottom of the screen so the users
can not navigate to existing records.

2) You will have to write your own code for this, the wizard will not
create it for you.

Rick

 

[Guest]

How do I take the record navigation off I tried in design view?
Thanks

 

[Rick Brandt]

How do I take the record navigation off I tried in design view?
Thanks

Set the property "Navigation Buttons" to No. You'll find it on the {
Format } tab of the property sheet.

 

[Guest]

Thanks it works.
Just one little thing if I open the form a record apears in the fields, I
want the form always to start with a new record.