Hi all,

Does anyone know the best way to make a control or label visible or invisible given a certain circumstance?

-If a user input from one form matches a number in the library I want a button and a label to be invisible on the next form that comes up. Otherwise, I want the button and label to be invisible.

Thanks for any input,

Dave

I am not sure what the sequence of events are.

Basically set the label and button to Visible = No as the default, and then use events (including the forms on current event) to check the value and set the property based on the value.

Where will the value be stored and how referenced?

mmcdonal

The user inputs a design number in a textbox
The number is stored in variable mycnt
A query counts how many #'s match the one that was input

If the query counts one or more then a form opens with the matching records displayed on the screen.
If the query doesn't find a match then the form opens with a label saying no match and a button that can add the new #.

DoCmd.Requery
Dim mycnt, mycnt_new As Integer
mycnt = DCount("*", "Q_check_exist")
If mycnt >= 1 Then

David

Are you saying set the button and label to Visible = No in properties or in the code?


dave

labelnomatch.visible = cbool(mycnt=0)
button.visible = cbool(mycnt=0)

If mycnt >= 1 Then
    'Open form displaying designs
Else
    'Open different form stating no such record found, with button to add new record
End If

I don't believe you need to manipulate visibility to solve that problem.

Thanks for the feed back guys!

I tried the CBOOL code, but couldn't quite get it to work for me.
I think I may just go for the multiple form approach.

Thanks again,

-Dave