Check box to SAVE record

[Gilberto]

Hello

I created a form where the user has to enter some information which will change over time. Every time the user fills up a form, the time and date are recorded.

I have the problem that if the user hits "tab" on the keyboard the form will go into a new record (thus leaving the last form with missing information, empty records). In order to correct this i added a check box which is required (in the table field properties) so that the user HAD to check the box in order to save the record and be able to GO to a new, empty record. However if you check AND uncheck the box (leaving it UNCHECKED) it will STILL allow you to go to the new record.

How can i fix this???
Also what can i do so that once a record is "saved" it cannot be edit, but only deleted (i already created the delet button, which works).

Thanks

[missinglinq]

You don't really need the checkbox for this purpose. In the form's Property box simply goto Other tab and set Cycle property to Current Record. This will prevent <Tab> from going to another record.

To prevent editing of a saved record, goto the form's Property Box goto Data and set Allow Edits to No.

Linq ;0)>

[cyberdwarf]

Gilberto

have the problem that if the user hits "tab" on the keyboard the form will go into a new record (thus leaving the last form with missing information, empty records)

Two things to look for:-

1. ALWAYS validate the data for fields which must have a value - you can do this,eg, on the Current event of the form, and/or you can write validation code for the required fields;
2. Some people (including myself!) don't like the default TAB key behaviour (non-intuitive??). Setting the Cycle property of the form to Current Record will allow you to force the user to click a 'Save' button, for example.

To allow delete-only for existing records, simply set Me.AllowEdit = False on the Current event, if the record is not new:-

If Not Me.NewRecord Then
        Me.AllowEdit = False
End If

HTH

Steve

[Gilberto]

Gilberto

Two things to look for:-

1. ALWAYS validate the data for fields which must have a value - you can do this,eg, on the Current event of the form, and/or you can write validation code for the required fields;
2. Some people (including myself!) don't like the default TAB key behaviour (non-intuitive??). Setting the Cycle property of the form to Current Record will allow you to force the user to click a 'Save' button, for example.

To allow delete-only for existing records, simply set Me.AllowEdit = False on the Current event, if the record is not new:-

If Not Me.NewRecord Then
        Me.AllowEdit = False
End If

HTH

Steve

Thanks guys,

The cycle property on current record works perfectly, thanks...simple thing i really had no idea, so i have eliminated the check box. BUT now I still cant get the "no edit" to work.

Right now i have:
Every property on YES, except the DATA ENTRY.
I applied the NO to the edit property and it doesnt work. It STILL allows to edit past records. (i created a couple of new records and i can just go to previous and modify the information). Then i also tried DATA ENTRY=YES + EDIT=NO and same thing...i created NEW records and i can STILL move around and modify previous records.

I also tried the following, but i get: "compile error, method or data member not found":

Private Sub Form_Current()
If Not Me.NewRecord Then
        Me.AllowEdit = False
End If
End Sub
 

What i need is that once i go to a NEW/next record, that if i return to this last one i WOULDNT be able to modify it..only delete it by the "delete" button i already have. I dont really understand what "validating" the data is, maybe this is the error, but doesnt the "next record ">"" button on the navigation suppose to VALIDATE the data???

Thanks again,
Gilberto

[cyberdwarf]

Gilberto

Validation means checking that the on-screen fields you know MUST contain data actually DO contain data of the correct type, in the correct format, within the correct range of values, etc.

This can be done in several different places in your code:-

• in the Change event of the field;
• in the code for a Save button (if you have one);
• using the ValidationRule and ValidationText properties of the field you wish to validate;
• in the Current event for the form.

Look for "validation" in Help.

HTH

Steve

[Gilberto]

Gilberto

Validation means checking that the on-screen fields you know MUST contain data actually DO contain data of the correct type, in the correct format, within the correct range of values, etc.

This can be done in several different places in your code:-

• in the Change event of the field;
• in the code for a Save button (if you have one);
• using the ValidationRule and ValidationText properties of the field you wish to validate;
• in the Current event for the form.

Look for "validation" in Help.

HTH

Steve

Thanks Steve, i didnt know about this very well. Ive read the topic however i dont think this is creating the problem where i can STILL edit the records eventhough the allow edit=NO. At the same time i still CANT get your code to work.

any ideas?
Gilberto