Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Qry Update in a form

Status
Not open for further replies.

puppy39

Programmer
Mar 13, 2009
41
US
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top