I have a form / subform / Query problem I need help with. I have a form with a subform and have used a query to generate a report from the information entered into the form. The query is related to the form by the following 2 where statements: [Forms]![frmPrescriptionsA]![fldRXID] and Forms]![frmPrescriptionsA]![frmDoses Subform].[Form]![fldDoseID].
The problem is that when I fill out a new record in my form and subform and then use the command buttons I have to either print or e mail the reprot that is based off the query the report is empty or unpopulated. If I go back one record then forward the the record I just entered the report now has the right information. I have tried a number of save commands to save the record first before trying to print or e mail and nothing has worked. Any ideas how to updat the form and query without closing the form or going to another record?
The problem is that when I fill out a new record in my form and subform and then use the command buttons I have to either print or e mail the reprot that is based off the query the report is empty or unpopulated. If I go back one record then forward the the record I just entered the report now has the right information. I have tried a number of save commands to save the record first before trying to print or e mail and nothing has worked. Any ideas how to updat the form and query without closing the form or going to another record?
