Navigation Form - don't click

[carmenv323]

I have a Navigation Form with buttons to activate different forms.

My issue is that when a user is on a form they will sometimes, for whatever reason, click on the area away from the form - in the navigation form area which erases the form



How can I make that area not clickable without disabling the buttons? or prevent the form from erasing?

Do I make sense?

[ranman256]

what is causing it to erase? normally, clicking off the form simply SAVES the data.
is there code in it to cause it to erase? NO entry form ever created naturally erases data.

what MIGHT be happening is the form went to the next record.

(but the record would still be saved in there)

to fix, set the CYCLE property to : Current Record

[Micron]

in the navigation form area

This means the area below the nav buttons (assuming yours are located one below the other)? The control that contains the buttons does have events listed for it but I have found that they don't fire (at least not the click event).

If you mean they're clicking on navigation buttons, then yes, the form in view will close (if that's what "erase" means in this case). Those buttons do have the 'enabled' property but I have not tried disabling that. The only time I bother with nav forms is when helping out here, so my knowledge of them is a bit limited.

[carmenv323]

The Cycle property is set to Current Record already.

I added data to the form, then clicked away from the form into the navigation form and the form reset itself.

[Bob Fitz]

Can you post a copy of the db

[carmenv323]

I was able to get around it by adding DoCmd.Save on LostFocus of the form.

Thank you

[Bob Fitz]

I was able to get around it by adding DoCmd.Save on LostFocus of the form.

Thank you

AFAIK the default behaviour is for a bound form save new/edited data when the focus leaves. No code required. I don't think the code you are using will save data. I believe it is used to save changes to design of the form.

[Micron]

Have seen that mentioned before. Create a new record and click save button on ribbon and record will save. I don't think it's because focus is lost on the form. M$ documentation says " form" will save - whatever that is?