I have a main form called Companies and two subforms in a Tabcontrol
TAB1 - SubformActive, RecordSource: qryActive, Criteria: Status = "Active"
TAB2 - SubfromInactive RecordSource: qryInactive, Criteria: Status = "Inactive"
When I change the combo box from active to inactive on the forms then click on the saved button I get the following message:
"The data was added to the database but the data won't be displayed in the form becuase it doesn't satisfy the criteria in the underlying record source"
I click OK and click my save button again and then everything is refreshed correctly.
How do I get rid of the message popping up and having to click on the save button twice. Any suggestions
TAB1 - SubformActive, RecordSource: qryActive, Criteria: Status = "Active"
TAB2 - SubfromInactive RecordSource: qryInactive, Criteria: Status = "Inactive"
When I change the combo box from active to inactive on the forms then click on the saved button I get the following message:
"The data was added to the database but the data won't be displayed in the form becuase it doesn't satisfy the criteria in the underlying record source"
I click OK and click my save button again and then everything is refreshed correctly.
How do I get rid of the message popping up and having to click on the save button twice. Any suggestions