Conditions in Continous forms

  • Thread starter Thread starter Linda.
  • Start date Start date
L

Linda.

I have a continous forms where 2 bitmaps are placed on.
A bitmap of word and one of excel.

on the current event of that form.
I have the following code:

If extension = "doc" Then
Me!picword.Visible = True
Me!picexcel.Visible = False
Else
If extension= "xls" Then
Me!picword.Visible = False
Me!picexcel.Visible = True
End if
End if

The problem is that if i have several records in that
forms with different extensions then all my records shows
the bitmap of word and when I move the cursor to a record
with extension = "xls" then ALL my records show the
piture of excel.

Is there a solution for this? TIA.
 
Not if you use a continuous form. A continuous form is actually only ONE
form, but it is redisplayed for each record. If the visible property is set
to true for one record it will be true for all records until you change it.
 
Back
Top