Help with update

[Bronte1226]

I have a form that has a tab control whith several tabs that each have their own subforms linked on a field to the main form. This database is over a year old and has served our purposes well. The user could add new records to the subform for each main record with no problem. However, lately one of these forms has stopped updated the linked field when a new entry is entered in the subform, so when the user moves off the main form record, the subform record is "lost" since it is not linked to the main form on that field.

I don't understand why all of a sudden this is happening. How do I correct this? I know that you can set a field to another value through vba but how do you do this through tabs and where do I put that code? on the on focus of a field, the form or the tab?

 

[JoeAtWork]

If this used to work and now stopped, your code is probably corrupted on that form. If Compact & Repair or recompiling doesn't work, the easiest method to try to fix I can think of is to:

1. Delete the subform
2. Add it back in
3. Give the subform the same name as previously
4. Reset the Master/Child key links
5. For any events of your subform that have code, "jump" into the event subroutine from the property page of the subform (I know that sounds stupid, but I have found that a necessary step, otherwise the control doesn't "rebind" to event code)