SetFocus syntax

[Rich]

What happens if you go to a new record after tabbing through the empty fields?

 

[Angelflower]

I tried tabbing all the way through my form and then closing the form thereby saving the new record to the underlining table and nothing happens.

 

[Rich]

But if there's nothing in it surely there's nothing to save?

 

[Angelflower]

At least not in that field there is nothing to save but the problem is that I need something in that feild for me to caluclate other fields even if it is a zero. This one field must be verify by the user before proceeding to any other field on the form. I cant use validation rules in the actual table because I am particially populating the form/table with a query when it frist opens. I want the user to finish filling in the fields on the form.

 

[Rich]

Force them to enter a zero then

 

[wazz]

if a value is required before the form closes look for it/check it on the unload event - which can (also) be canceled - then return the user to the control (or set the value in code). but of course, rich is right, nothing there, nothing to save. before update will only work if data changes in the control. tabbing through changes nothing.

 

[Angelflower]

Force them to enter a zero then

How do I force them to enter a zero?

 

[Rich]

Use a validation on one of the fields in the table

 

[Angelflower]

I tried that but since I am populating some of the fields in the table before the form opens and that field is not one of them I get an error saying I am violating the validation rules.

 

[Angelflower]

I give up.. I am going to try and go about this differently. I am going to try and populating the field with zeros to start with when I pull in the other data via my query.