Saving... I don't think so but ==> how no to???

[Bigpapou]

Hi,
it's has simple as this... I have a form with a table "tbl" for source and I don't wan't that form to save the data as it close. I've tried doing this:

Sub ..._onLiberation(...)
Me.Dirty = False
End Sub

I tought it would work but it did not and since it's the only thing I could come up with well, I'm stuck.
!!! HELP ME !!!

 

[jerseyboy]

There are a number of ways to accomplish what you are looking for. The question is why do you want to not save changes.

If you are using the form for a "practice" form, then make all of the controls unbound. Simulate that it is an entry for the table.

If you are trying to make it read only then open it in design view, and right click on the square in the top left corner and select properties.

The answer lies in the DATA tab. There are properties in there that will restrict the user.

If there is another reason that I haven't covered try to elaborate some more.

Good luck! JerseyBoy
Remember: self-praise is no recommendation

 

[CTOROCK]

JerseyBoy is correct Just make the controls unbound

CTO

 

[CTOROCK]

oh, one more thing you probably are using the button wizard, so you need it bounded. you are probably going to have to use the
rst.addnew
rst.fields("Name&quot = txtname.value

sort of thing.

Or you can wipe out the fields as you close the form:
txtname.value = ""
etc.