Single record data entry

[w0od0o]

hi, i am trying to get my form to be a single entry and stop it going to record 2 any help is appreciated

thanks

w0od0o

 

[PaulJR]

It sounds like it isn't entering data, but viewing your records only. If this is the case, I seem to recall that you will need to change the properties of the form in design view. This was certainly an issue I had.

Go to 'Edit' - Select Form
Then 'View' - Properties.

On the window that pops up, under the data tab, ensure you have 'Allow Additions' and 'Data Entry' set to yes.

 

[w0od0o]

thanks for the quick reply, i might not of explained myself to good, the form is working fine and add the data to the table fine but when i come to the end of the form it will allow a new record and i only want to add 1 record at a time then close the form.

thanks

w0od0o

 

[PaulJR]

Some questions:

Do you want the form to display current records too? Or do you only need the form to be used to enter single records?

Are you currently using the default record navigation buttons to skip through and save records?

 

[w0od0o]

no i dont want to veiw the records i just want to enter data single page form then it is stored

 

[PaulJR]

If you go back to the properties page (described above), try the following settings:

Under the Data Tab:

Allow Edits: No
Allow Deletions: No
Allow Additions: Yes
Data Entry: Yes

Under the Format tab, you can also turn the record selectors and navigations buttons off as well...if you wish (Press F1 for help on each setting). You could then add a command button (from the toolbox) to the form to save the record.

 

[w0od0o]

thank you very much

have a feeling ill be posting on here alot

 

[PaulJR]

Post away! I have had tons of help from this site so its good to help out occasionally