How do make a datahseet unbound?

[projecttoday]

I would like to know how to make a datasheet subform unbound. I need this so I can can cancel changes. How do you save changes on a datasheet to a table if the form is unbound?

 

[MajP]

You can do this with a pseudo unbound form. Bind the datasheet to a temp table. Load the table with the related records and then commit the records to the real table when done. You will have to avoid using an autoid key.

I guess you could use a flexgrid to really make an unbound form. I have never personally tried that.

 

[projecttoday]

A flexgrid in Access?

 

[MajP]

Of course. There are lots of examples out there.

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=180

 

[projecttoday]

Thanks. I'll take a look at it.

 

[TheAceMan1]

How are ya projecttoday . . .

Is the start of this thread an entension of thread702-1550447?

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]