Validation Rule? IF (Field A) = (Cell Value), then Field B ok

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

T.Kay - 31 May 2007 16:48 GMT

For example
Field A = ID #'s
Field B = Characteristics from a drop down value list.

If [FieldA] = "32", then [Field B] Must be entered/selected (in the form)

I want the value list to activate on the form if Field A is "32"

Not sure if this is possible.

Thank you in advance,

T

Reply to this Message

Maurice - 31 May 2007 18:20 GMT

Well you could try something like:

set control "b" to enabled=false

after_update textbox "A"

If [field A]="32" then
[fieldb](or combobox).enabled=true
else
[fieldb](or combobox).enabled=false
end if

Signature

Maurice Ausum

> For example
> Field A = ID #'s
[quoted text clipped - 9 lines]
>
> T

Reply to this Message

T.Kay - 31 May 2007 20:57 GMT

For the example i stated it works, however:

I may be doing something wrong in visual basic, but I keep getting and error
message stating the Procedure name does not match.

I think it may be because of this:

My Field A row source is as follows:
SELECT [Table_Contribution_Type].[Cont_Type_ID],
[Table_Contribution_Type].[Cont_Type] FROM Table_Contribution_Type;

Which is making it a little more difficult.

Thank you again in advance...

> Well you could try something like:
>
[quoted text clipped - 21 lines]
> >
> > T

Reply to this Message