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

Form cross-field edits

P: n/a
On a form I developed, I want to do some cross-field dependencies. If
field1 = "xxx" then field2 must be "yyyy" and so forth. Apparently I
cannot do that in field properties via the validation as you cannot
refer to other fields in a form. Right now I am doing these in a
"BeforeUpdate" VBA routing. However, the update continues and the error
message becomes informational - not a "fatal" error.

Anyone have a better way of doing such, especially a way to stop the
update and ensure that the changes get made to the edit rule is passed?

Thanks.

Bob Alston
bobalston9 AT aol D O T com
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Bob Alston wrote:
On a form I developed, I want to do some cross-field dependencies. If
field1 = "xxx" then field2 must be "yyyy" and so forth. Apparently I
cannot do that in field properties via the validation as you cannot
refer to other fields in a form. Right now I am doing these in a
"BeforeUpdate" VBA routing. However, the update continues and the error
message becomes informational - not a "fatal" error.

Anyone have a better way of doing such, especially a way to stop the
update and ensure that the changes get made to the edit rule is passed?

Thanks.

Bob Alston
bobalston9 AT aol D O T com

OK. Found that "beforeupdate" routines have a "cancel" variable
allowing you to cancel the update. Slick.

that allows me to do my complicated edits in a "before update" routine.

Also found some slick code that is a generalized method of producing
error messages for missing required fields. It lists all missing fields
in one msgbox and aborts the update.
See the Message from Dave - a few down in the thread.
http://64.233.167.104/search?q=cache...+message&hl=en

Also he has a syntax error or two but you get the jest.

Bob
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.