Using unbound sub-forms!!

[jscully]

Greetings

I am developing an MIS system for my company. It has an SQLServer2000 backend and an Access2000 frontend.

My question is: Is it possible to create an order entry screen with a Master form contain a sub form, but the sub form must be unbound? I say unbound because, I do not want any records written to the backend until the user has finished entering all of the sub form records! Therefore, I wish to maintain control over the data with my own code.

Any help would be very much appreciated!

Joe

 

[pcs]

i usually handle this by making the subform bound to a temporary table on the user's f/e.

when entry is complete, i use an append query to update the master b/e table and then a delete query to clear the temp...

hth,
al

 

[jscully]

Al

By saying "I usually handle this....", I presume that you and other members of the board have come across this situation before. Therefore, will I assume that this is the best solution?

If it is, then thank you very much!

Joe

 

[pcs]

joe,

yes, i have encountered this before...

i don't claim that this is the 'ultimate best solution', but it is a solution and easy to implement.

access has a very large range of tools. you can accomplish a given task in many ways.
other members may want to offer other solutions.

al

 

[jscully]

Al

Thanks very much for your help!

Joe