[AccessD] VBA Unbound data entry / update form

LOL.

You know what, I may yet use a piece of that.  I am not sure 
if the "separate table" is useful or not.  I would be 
interested in hearing how you came to use that construct. 
The "partially bound" with the memo itself unbound is a 
brilliant idea.  Kinda "the best of both worlds".  the 
record lock does not take effect because of an edit to the 
memo (which is the only field edited the second and 
subsequent times) and the locked flag would solve the rest.

So why the separate table for memos?

John W. Colby
www.ColbyConsulting.com


Gustav Brock wrote:
> Hi John
> 
> So why not try out #48 (mine)? It works and is so simple that it hurts.
> It will only lock the memo field for the split second it takes to save it. Lunch break or not.
> Add a field for a locking flag as suggested by Max and you are nearly done - still having your form bound.
> 
> /gustav
> 
> ..  I have had about 47 posts COMPLETELY IRRELEVANT ..
> 
> 
>