How to create unbound Subform (Datasheet)

bhuttak

New member
Local time
Today, 23:59
Joined
Feb 9, 2006
Messages
5
Hi Friends,

I want to create unbound subform. As per your exprience can some one help me. subform must be Datasheet veiw. Thanks
 
This is not something that even I would attempt. What is the purpose of having an unbound form in datasheet view?
 
Well is it possible to unbound subform in datasheet view. I have sales program and I found some time user make mistake. and I don't want to save the record unless I save it by coding. if we have unbound subform. the problem is 0%.
 
If you learn how to use form events, the problem is 0% with bound forms also and with far, far, far less code. If you are having trouble controlling record updating, you are not using the form's BeforeUpdate event properly.

Well is it possible to unbound subform in datasheet view.
Practically anything is possible if you are willing to spend the time to code it. For starters, Access doesn't support control arrays - this is not a failing with Access. It does not need to support control arrays because it supports bound subforms. Since there is no array, you would need to decide how many rows your unbound form would show. You would need to control populating the controls, you would need to control updating the table, you would need to control scrolling forward and backward, you would need to provide error handling, you would need to provide delete capability, etc. Essentially, everything Access does for you with a bound form, you have to code yourself.
 

Users who are viewing this thread

Back
Top Bottom