How to update/amend data in the continuous form

[Kristaline]

Hi,

I am looking for a solution how to update/amend the existing records within continuous forms.

Thanks.

 

[James Dudden]

Do you mean update all the records?

 

[boblarson]

What do you mean exactly? I update/amend records in a continuous form by typing in the record. What do you need updated/amended?

 

[Kristaline]

My project is for one tutor to create a small database. The main form has STUDENTS DETAILS and in the subform employer's projects which are assigned to the student/students.

I have a button which opens the PROJECT form where I am selecting an employer and then add the project. If employer doesn't exist in my listbox, I have other button to open another form EMPLOYER - to enter company info.

My forms have SAVE, CLOSE, ADD buttons. But how to amend the records if there is any mistake and therefore prevent any empty textbox - I want to warn the db user that some data is missing and won't save until confirmed/added info.

Also, I have coded with VBA when closing the continuous forms to refresh the data to populate on the main form.

I hope it's clearer now. Thanks

 

[James Dudden]

You could add a validation rule.

To do this open the table in design view and select the field in question.
On the General tab type the following code in the Validation Rule field:

Is Not Null

Now in the Validation Text field add the message you would like to give the user e.g.

The field Employer must not be left empty

Hope that helps
JD