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

[T.Kay]

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

 

[Maurice]

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

 

[T.Kay]

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:

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

--
Maurice Ausum

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