Proofread code - Make field visible based on value in another field

[nedryerson]

Hi,

I'm trying to get a certain field to appear only when a value from another combobox field is selected. Specifically, when "Sample Rejected" is selected in the field "PcrLabResults, " I would like the "ReasonsRejecte d" field to appear. I've set the visibility option for "ReasonsRejecte d" to "No" already. I still can't get it to work. Do I need to do anything after entering this code (ie save, click "run," etc), or will it update in the form automatically? Here's my code - please let me know what I'm doing wrong. Many thanks in advance.

Private Sub PcrLabResults_AfterUpdate()
  If Me.PcrLabResults = "Sample rejected" Then
    RejectionReasons.Visible = True
  End If
End Sub

PS - I've looked at these two threads, and still can't seem to get it right:

http://bytes.com/topic/access/answers/884123-cannot-get-form-show-field-based-value-another-field

http://bytes.com/topic/access/answers/854100-how-do-i-hide-form-field-only-show-based-value-another-form-field

[missinglinq]

Well, first off, you give the control name as ReasonsRejected in your post, but use the name RejectionReason s in your code. Which is it?

Linq ;0)>

[nedryerson]

Sorry about that - it's "RejectionReaso ns." Still won't work...

[NeoPa]

I would change the code slightly so that it both sets and resets the visibility status of the other control :

Private Sub PcrLabResults_AfterUpdate()
  RejectionReasons.Visible = (Me.PcrLabResults = "Sample rejected")
End Sub

That said, I see no reason why your code wouldn't work as it was. Can you try this and let us know what you get. The clearer your response, the better able we'll be to help.

[missinglinq]

Also

1. What version of Access are you running?
2. What kind of form are you using? Single, Continuous or Datasheet?
3. What exactly do you mean by "I still can't get it to work" WHat happens?

Linq ;0)>