Disable save in forms

[andvidal]

Hi, I have a little problem. (I think it's a very noobie question )

When I close a form, the program tries to save a record, generating several errors.
There's a way to disable that?

Thanks!

[ranman256]

if you set the form property : RECORDSET TYPE = SNAPSHOT.
users cannot save

or
ALLOW EDITS = FALSE

[andvidal]

Didn't work. I will try to explain myself better.

I use a form, for example, to input a UserID into a query. The UserID input is linked with the Users table, because I use a list.
But then, when I have to close the form, the program tries to create a new register with the UserID.

I'm trying to use the correct words , but I'm not English native speaker, and probably there will be a lot of mistakes. (I use the program in another lenguage).

Any idea?

[aytee111]

You can use Me.Undo in the OnClose event.

[andvidal]

me.undo didn't work either

[John_G]

Is the form a login form, which where the user selects the ID from a listbox? If so, the form probably does not need a record source, because it is not adding data to anything. Try removing the record source from the form's properties.

[andvidal]

I tried that too. But if I remove the record source from form's properties I can't generate the listbox.

EDIT: I solved it, just have to use me.undo in before add and before update events.

Thanks everyone for your help !

[orange]

andvidal,

You can write your description in your native language with as much detail as needed. Then use Google translate to convert it to English and post it.
Would also help if we could see the database --please provide instructions on how to get to or reproduce the error.

A Form has a recordsource.

A Listbox has a rowsource.



Good luck.

[John_G]

But if I remove the record source from form's properties I can't generate the listbox.

Then you are doing something wrong to create the listbox. The items in a listbox do not depend on the record source of a form.

How are you creating the list of items in the listbox?