Values Disappear when holding mouse over fields

  • Thread starter Thread starter Veronica Z
  • Start date Start date
V

Veronica Z

Hello Everyone!

I have created a form that has a subform as seen here:
http://img.photobucket.com/albums/v467/xveronicazx/form.jpg

In the Subform, when I select the product from the drop-down menu, the
version is then also a drop down menu showing only the available
versions for
that product selected.

The code for the subform is as follows:
Private Sub Product_AfterUpdate()
Me.Version.RowSource = "SELECT Versions.VersionID, Versions.Version
FROM" & _
" Versions WHERE ProductID = " & Me.Product & _
" ORDER BY Version DESC"
Me.Version = Me.Version.ItemData(0)
Me.Version.SetFocus
End Sub

Private Sub Version_GotFocus()
Me.Version.RowSource = "SELECT Versions.VersionID, Versions.Version
FROM" & _
" Versions WHERE ProductID = " & Me.Product & _
" ORDER BY Version DESC"
End Sub


My problem is that if I go select/modify a product to the same one or
another, when my mouse moves over the version field for another record,
the
values all disappear and only shows the versions of the last product I
selected.
http://img.photobucket.com/albums/v467/xveronicazx/problem.jpg
Lets say there is a different product listed but has the same version
of the
last product I selected, that version field will still display. Very
odd.

Any ideas?
 
Back
Top