ACCESS FEED: Re: [MS_AccessPros] Subform didn't show

Sabtu, 31 Oktober 2015

Re: [MS_AccessPros] Subform didn't show

John-

I did put code in AfterUpdate event. It didn't show the subform, finally I put a command button to achieve. Thanks a lot.

Best Regards,

Kevin

在 "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年10月31日下午6:36写道：

Kevin-

That code runs only when you move to a different row in your record source. If you want to reveal the subform after you've entered something in GroupBookingID, then you need to use the AfterUpdate event of that control.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

On Oct 31, 2015, at 10:10 AM, 'zhaoliqingoffice@163.com' zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Dear All,
I use use "visible" to show and hide a subform, after input some data, the sub form still didn't show. Please help.

Private Sub Form_Current()
On Error GoTo ErrHandle

If IsNull(Me.GroupBookingID)  Then
Forms!frmGroupBooking!subPart.Visible = False

Else
Forms!frmGroupBooking!subPart.Visible = True
End If

ErrExit:
    Exit Sub

ErrHandle:
    Resume ErrExit
End Sub

Best Regards,
Kevin

Regards,
Kevin Zhao

From: 'zhaoliqingoffice@163.com' zhaoliqingoffice@163.com [MS_Access_Professionals]
Date: 2015-10-31 16:20
To: MS_Access_Professionals
Subject: [MS_AccessPros] Subform didn't show

Dear All,
I use use "visible" to show and hide a subform, after input some data, the sub form still didn't show. Please help.

Private Sub Form_Current()
On Error GoTo ErrHandle

If IsNull(Me.GroupBookingID)  Then
Forms!frmGroupBooking!subPart.Visible = True

Else
Forms!frmGroupBooking!subPart.Visible = False
End If

ErrExit:
    Exit Sub

ErrHandle:
    Resume ErrExit
End Sub

Best Regards,
Kevin