Qry Update in a form

[puppy39]

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

 

[sqlprograms]

The error
"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"

mostly occurs when the Server Filter or Filter is saved in the form, This is happens while you are opening a form using a filter and at the same time you choose the design view.(This may be one of the case)

For this go design view and clear the filters.

SQL Server Programmers

http://www.sql-programmers.com/