Visible or Invisible ?

  • Thread starter Thread starter Gulf Coast Electric
  • Start date Start date
G

Gulf Coast Electric

I have an unbound drop down search that after update it searches for the
record and then goes to it.
Code is below:

Set rs = Me.Recordset.Clone
rs.FindFirst "[TimeID] = " & Str(Me![Combo202])
Me.Bookmark = rs.Bookmark
Me![Combo202] = Null

I also want to show on top of this drop down list a label that says Search
The label is named LabelSearch , I want this label to be visible until after
you click on the drop down list and then be invisible.
Where would I put the code to do this?
I have the code that i believe will work for this:
Forms![TimeCards]![Labelsearch].Visible -1


Would also like very much for a message box to popup that says this record
has been archived if no result.
 
You could try putting this in the combo's OnClick() event....

LabelSearch.Visible = False

Then you just need to figure out where to make it visible again.

HTH,

T.
 
I have an unbound drop down search that after update it searches for the
record and then goes to it.
Code is below:

Set rs = Me.Recordset.Clone
rs.FindFirst "[TimeID] = " & Str(Me![Combo202])
Me.Bookmark = rs.Bookmark
Me![Combo202] = Null

I also want to show on top of this drop down list a label that says Search
The label is named LabelSearch , I want this label to be visible until after
you click on the drop down list and then be invisible.
Where would I put the code to do this?
I have the code that i believe will work for this:
Forms![TimeCards]![Labelsearch].Visible -1

Would also like very much for a message box to popup that says this record
has been archived if no result.
Click to expand...

The problem is that once you make it not visible it will be not
visible until you then make it visible again.

In the Combo Box AfterUpdate event:
Me!LabelSearch.Visible = False

You'll have to decide where you then wish to make it visible again.
Perhaps in the Form's Current event:
Me!LabelSearch.Visible = True
 
Thanks, So if the search result produces no record, then how would I make
it display a message box saying
record not found?

--
-------------------------------------------------------------------------
Thanks for your Help.
T. said:
You could try putting this in the combo's OnClick() event....

LabelSearch.Visible = False

Then you just need to figure out where to make it visible again.

HTH,

T.


Gulf Coast Electric said:
I have an unbound drop down search that after update it searches for the
record and then goes to it.
Code is below:

Set rs = Me.Recordset.Clone
rs.FindFirst "[TimeID] = " & Str(Me![Combo202])
Me.Bookmark = rs.Bookmark
Me![Combo202] = Null

I also want to show on top of this drop down list a label that says Search
The label is named LabelSearch , I want this label to be visible until after
you click on the drop down list and then be invisible.
Where would I put the code to do this?
I have the code that i believe will work for this:
Forms![TimeCards]![Labelsearch].Visible -1


Would also like very much for a message box to popup that says this record
has been archived if no result.
Click to expand...
Click to expand...
 
Back
Top