Hi all,
I have a main form 'Customers' that is supposed to use 2 subforms to pull information that corresponds to a customers ID number. The ID number is entered by the user into the main form - the subforms are then supposed to retrieve the customers mailing info 'custmail' and the second one the customers purchase orders 'custpurch'. This seems to work flawlessly for the customers that were in the DB BEFORE the form was created. However, all new customers that are entered are not accessible from the forms. I thought this was because the subform was not getting the information but if you pull the subforms up individually and manually scroll through the entries the new customers show up just fine. Is there a way i can force the main form to pull from these updated subforms and not just the information that was present when the main form was originally created? This has been stumping me for almost a month and any input would be greatly appreciated
Thanks in advance
-Sean
I have a main form 'Customers' that is supposed to use 2 subforms to pull information that corresponds to a customers ID number. The ID number is entered by the user into the main form - the subforms are then supposed to retrieve the customers mailing info 'custmail' and the second one the customers purchase orders 'custpurch'. This seems to work flawlessly for the customers that were in the DB BEFORE the form was created. However, all new customers that are entered are not accessible from the forms. I thought this was because the subform was not getting the information but if you pull the subforms up individually and manually scroll through the entries the new customers show up just fine. Is there a way i can force the main form to pull from these updated subforms and not just the information that was present when the main form was originally created? This has been stumping me for almost a month and any input would be greatly appreciated
Thanks in advance
-Sean
