By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,521 Members | 1,252 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,521 IT Pros & Developers. It's quick & easy.

change data then it does not satisfy criteria in the underingly table

P: n/a
I have two access forms:
form 1 based on query "select * from customer where ynValid=1"
form 2 based on query "select * from customer where ynValid=0"

On form 2 there is a checkbox bind to ynValid field, when user check
this checkbox it set ynValid=1. I want bring the record back to form 1
when user check ynValid checkbox.

When I check the checkbox there are errors "the data is added to
database but it won't display on the form because it does not satisfy
criteria in the underingly table" and "multiple steps failed, please
check each step"

How can I get around of it?

Thanks in advance
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
maybe on the afterupdate event of [forms]![form2]![.ynValid], requery form
1????

Mark

"Rebecca" <rh********@yahoo.com> wrote in message
news:14**************************@posting.google.c om...
I have two access forms:
form 1 based on query "select * from customer where ynValid=1"
form 2 based on query "select * from customer where ynValid=0"

On form 2 there is a checkbox bind to ynValid field, when user check
this checkbox it set ynValid=1. I want bring the record back to form 1
when user check ynValid checkbox.

When I check the checkbox there are errors "the data is added to
database but it won't display on the form because it does not satisfy
criteria in the underingly table" and "multiple steps failed, please
check each step"

How can I get around of it?

Thanks in advance

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.