Unbound subform linking

Bilal

Registered User.
Local time
Today, 16:25
Joined
Sep 30, 2013
Messages
64
im not really sure where im going wrong but this is the problem,

i got a form and subform, both unbound, i got a data create, update, delete system.

the main form is fully working, when i press my add button to enter data i am able to create/update/delete records however my subform just doesnt work, i just can not edit any of the fields while i am inmode "dirty" or inmode "new" however i can edit the fields when i am inmode "normal", i want to be able to edit it whatever mode i am in but after the keyup event i want it to automatically take my subform to a "dirty" state where only the save button is available and i can save records in my subform

this all works in my main form so i sort of know what i want, just cant execute it
 
Can you tell us in plain English what you are trying to do? How do your Form and subForm relate? Form/subform are typically used where there is a one to many relationship between the tables behind the form and subform.
 
Can you tell us in plain English what you are trying to do?

Thanks for the reply :)

okay below is my stripped database, if you look at the suppliers form and mess around with it, you can add data into the main form and it will quite happily save, and the data wil save in my tblSupplier also, however when i try to add data into the sfrm the information wont save into tblPerson, I know there must be a lot more behind it, like geting the PersonID field to work in both the main form and subform, but if you could point me into the right direction that would be highly appreciated :)
Regards
Bilal
 

Attachments

Users who are viewing this thread

Back
Top Bottom