If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
data entry in subform before mainform causes huge hassle, HELP!
Hello all
i have an application where there are forms which have subforms where it is entirely possible for the user to start entering data in the subform before the main form. this is proving to be a real pain. as soon as a user enters something in the subform and then moves from it to the main form and types (cause the on dirty state), the entered data in the subform is saved and disappears. basically because the link between the mainform and the subform is an autonumber field on the main form, which doesnt have a value until the user types in the main form, the main form doesnt get a record and the subform has nothing to put in the field that links it to the mainform. this causes orphan records in the subforms table. this is not a good situation because the user has to retype the record that they had in the subform after wondering where the record went. how do i stop this from happening? i have tried placing code on the form to put a value in the mainform on enter of the subform, this doesnt help and makes using the combo boxes in the subform to chose something an exercise in frustration. i have been working on this app for more than 2 years and just found this problem today. you would think that i would be getting complaints from the users on a regular basis. -- As always, any and all help appreciated! |
Thread Tools | |
Display Modes | |
|
|