Continuous Forms - Hiding and showing objects

S

SAm

Hi

I have a Continuous (bounded) Form where the users opens to New Entry
(DataEntry=True), then i have in the Form header three fields (unbounded)
which change the recordsource to a query based on the user's parameters. so
if the user enters 1, 2, or 3 parameters the form will show those matching
entries, and if the user then clears 1, 2 and 3 then only a new entry
(dataEntry=true) will show.

here is the issue, in order to economize on space i would like floating
lables that disappear when the user enters information. i wlll paste now a
sample of what happenes:

Private Sub cboAgencyID_Enter()
Me.lblAgencyID.Visible = False ' this is the label. it will disappear.
End Sub

Private Sub cboAgencyID_Exit(Cancel As Integer)
If IsNull(Me.cboAgencyID) Then ' if there is information, then we don't
a label
Me.lblAgencyID.Visible = True ' the label will appear
Else
Me.lblAgencyID.Visible = False ' the label will disappear
End If
End Sub

all works fine. its just when i show all fields, these labels are hard to
hide. i have seen some solutions on the web working with Continuous Forms. i
would like the following: only if i am showing a new record then i want these
labels to show, otherwise i don't need lables.

can anybody suggest something?

thanks,

sam
 
Top