Conditional Fields

[Dexsquab Molutinator via AccessMonster.com]

Greetings.

I have searched for an answer to my query for some time and have had no success. I'm hoping the pooled resources of all your brains can help.

How do you set a field to become active only if a certain condition is met?

I have several forms which are to be used for client booking and administration. Each has several fields which use a lookup across another table to ensure only valid values can be selected in those fields. I then have several fields to be filled out with text supplied by the user. What I want to do is set a conditional which will prevent anything being entered in those fields if the lookup field matches a certain value.

EG.

Referral Address
\/ __________________
[Group 1]
[Group 2]
[Group 3]

Referral is a drop down field that extracts its values by lookup from another table. In this example there are 3 cases for address, being:
1) Address is mandatory (say if Group 1 is selected)
2) Address is optional (this is the basic state as form now stands)
3) Address field condition not met, and no data can be entered there.

such that end results would be
(on selecting 1st) [Group 1] [data must be entered]
(on selecting 2nd) [Group 2] [data may be entered if necessary]
(on selecting 3rd) [Group 3] [no data can be entered]

--------------------
So... how do I do this? Your help will earn you a small gold statuette engraved with the word 'Monsteriffic!'

Dexsquab

--
Message posted via http://www.accessmonster.com

[splashout1]

Well this may help and compared to many here i am a complete novice so
some may give you a better method.

You know you can make a macro conditional (right click in the header
and select conditions)
These conditions can then be used to interegate the value of the drop
down list and run after update to set the corresponding attributes of
the other controls on your form.

eg along the lines of

condition = dropdown=1 action = setvalue controlname.enabled =
true/false

The macro can also be converted to code and you can use it in your own
coding.

As I said i am no expert but i hope it gives you a start
Hope it helps
Glyn

[Lumpierbritches]

Use an If Then Else Statement or Select Case Statements.

[Dexsquab Molutinator via AccessMonster.com]

Thanks for your assistance, however I still have had no joy.

I'll copy a code snippet, hopefully you can show me where I'm going wrong.

---------
Private Sub Referral_From_AfterUpdate()

If Me.Referral_From = "Self" Then
Me.[Name_of_Referee].Enabled = False
End If

End Sub
------------

This code element appears in the After Update field on the Referral_From field. Similar code appears in Before Update and Change. It does nothing... no errors, no disabling of related fields. I've tried square brackets around the Referral_From element, which doesnt seem to help. Set up as above it seems as though the code doesnt exist.

If I change "Self" to 4 (the ordinal value from the referrer table), it then crashes with a run time error whenever that option is selected. The error is as follows:

Run-time error '2465':

Microsoft Access can't find the field '|' referred to in your expression.

So, is it bad variable naming, incorrect syntax, or what? Any help would be wonderful.

--
Message posted via http://www.accessmonster.com