I
isobel26
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?
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?