K
KRosier
Hi Everyone!
Any help on the following problem would be very much appreciated. I'm
using MSAccess 2000 and have just a smidgen of experience with coding -
enough to know that something can be done, but not enough to figure it
out quickly. Thanks!
Kathy
I have two forms
CharSelect_frm contains an unbound listbox containing names
char_frm contains name, registered, subform, label with text message
When I doubleclick on the name in CharSelect_frm, it opens char_frm and
goes to the related record (actually filters it so only one record is
showing).
I used this code in the listbox doubleclick event
DoCmd.OpenForm "char_frm", , , "charID=" & [Char_names]
I would like either the subform OR the label to be visible depending on
whether the person is registered or not.
If I open char_frm by itself the code in the char_frm Current event
works properly. However, if I use the CharSelect_frm to open the
char_frm, it always returns the subform as visible. I suspect it's a
matter of finding the proper event to place the code in, but I think
I've gone through them all.
Private Sub Form_Current()
If Me.Preg = 0 Then
Me.char_frm_sub.Visible = False
Me.register_lbl.Visible = True
Else
Me.char_frm_sub.Visible = True
Me.register_lbl.Visible = False
End If
Any help on the following problem would be very much appreciated. I'm
using MSAccess 2000 and have just a smidgen of experience with coding -
enough to know that something can be done, but not enough to figure it
out quickly. Thanks!
Kathy
I have two forms
CharSelect_frm contains an unbound listbox containing names
char_frm contains name, registered, subform, label with text message
When I doubleclick on the name in CharSelect_frm, it opens char_frm and
goes to the related record (actually filters it so only one record is
showing).
I used this code in the listbox doubleclick event
DoCmd.OpenForm "char_frm", , , "charID=" & [Char_names]
I would like either the subform OR the label to be visible depending on
whether the person is registered or not.
If I open char_frm by itself the code in the char_frm Current event
works properly. However, if I use the CharSelect_frm to open the
char_frm, it always returns the subform as visible. I suspect it's a
matter of finding the proper event to place the code in, but I think
I've gone through them all.
Private Sub Form_Current()
If Me.Preg = 0 Then
Me.char_frm_sub.Visible = False
Me.register_lbl.Visible = True
Else
Me.char_frm_sub.Visible = True
Me.register_lbl.Visible = False
End If