Users entering a new record through a form?

[Shellie]

Hello!

Just need a little extra help

I have set up a form for the user to fill in a new record and used a command button for it to save. This all works ok.

The problem I have is when the form is opened, a record is shown in each of the fields as opposed to a blank one. The user can still enter data but they need to delete the stuff that is already in the box.

The user then, will have to press the little star at the bottom.

I have tried going into to design view, and typing in "Unbound" but it came up with #name? ...

can anyone help me ?

Shellie x

 

[Michael J Ross]

Open the Form in Design View and open it's Properties, on the Data Tab there is an item called Data Entry, change this from No to Yes.

When the form is opened up it will now open up with a blank record.

 

[Shellie]

When I open the data tab on properties it is just grey - no options I can select ?

 

[Michael J Ross]

Have you changed the fields back from Unbound to the record sources?

Also are you selecting the Properties by Right Clicking on the black square on the top left corner of your form?

 

[Shellie]

Sorted, I wasn't on the right properties!

Thanks xx