Allow Edits on Subform
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I have a main form with subform and looking lock the delections and edits but when I do that so subform is also locked and cant enter new data into it. I have done this for single form but with subform, dont know so far.
it is required bcz when ever open the form so bymistake the old data modified.
I have a main formlinked to a subform, within the subform, I have a second subform.
I am able to edit and add data in the main form, and the first subform. I am not able to edit or enter data into the second subform.
If I open the first subform directly without going into the main form, I have no problem entering data into the second subform.
All the properties are set to allow edits, allow additions, allow deletions
Then I edited the table bound to the subform simply to make one of its text fields longer; that's all!
Now, data from the subform table does not show up in the subform at all.
I can still add a new record via the subform, but I will only be able to see it briefly (while initially entering it). if I go to a different mainform record and then return to the one that should have the new subtable record, again, it doesn't show.
However, looking directly at the table for the subform shows that the new record (and the old ones) are indeed still allproperly there in their table.
Is there a way to Allow Deletions without allowing Edits. I need to have some control over what's going in and out of the database.
This only works for the parent-the subforms still allow edits (something that affects totals on the Parent)
which gives me an error message.
I am using A2007 with W7.
I know that I can open the whole form as read-only, but would like child1 to be available for editing. I have searched, and found things that I thought would apply, but am missing something.
This submit button makes the form footer appear where the save button currently hides.
Once saved the form footer then disappears again and the buttons return to enabled.
I created this format to add in fields of who/when/why the person is editing for quality assurance reasons when I knew more about what needed to be added. The fields within Form 1 need tobe archived with the editing reasons within a table.
I thought maybe a subform would work within the form footer for the editing fields as they work on a one-many relationship with each record. There are two problems with this method.
1 - Being that I need to bypass the update which occurs when the subform gains focus and have the save occur with both the form and subform.
2 - I have no idea how to keep the old records from Table 1 each time, I.e. If you need to edit a field in Form 1 and have previously edited it before that how could I go about saving allthe editable fields within Table 1 with a new record and not overriding the old one before edits?
If you can think of anyway to help me then even better.
I know I can go into the data tab of property and select "no" for 'Allow edits'. Is there a code or something I can put into a command button to change "Allow edits" to a "Yes'?
Or is there another strategy to limit accidental changes to data?
Btw, I'm still new to learning codes