Thomas
Maybe on the onload event of the main form you can try you new code but tell the subform to be visible if there is data
If SubformName.RecordSet.RecordCount = 0 Then
SubformName.visible = true
Else
MsgBox "Sorry but there are no records to display!"
Cancel = True
End If
Jim Wagner
________________________________
________________________________
From: Thomas <thomas_lam_us@yahoo.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, July 25, 2012 11:44 AM
Subject: Re: [MS_AccessPros] Do not display a form if the control source (a query) return no rows
Thank you Gentlemen
Now I have another challenge.
What if the form is a subform? I understand there is OnChange event using the TabControl. How do you suppress the display of the form?
Regards,
Thomas
--- In MS_Access_Professionals@yahoogroups.com, Jim Wagner <luvmymelody@...> wrote:
>
> RobertÂ
>
> I like that better.Â
>
> Thank You
> Â
> Jim Wagner
> ________________________________
>
>
>
> ________________________________
> From: Robert Peterson <bob@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Wednesday, July 25, 2012 10:52 AM
> Subject: RE: [MS_AccessPros] Do not display a form if the control source (a query) return no rows
>
>
> Â
> I think this is pretty quick and easy
>
> If Me.RecordSet.RecordCount = 0 Then
> MsgBox "Sorry but there are no records to display!"
> Cancel = True
> End If
>
> Bob Peterson
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Thomas
> Sent: Wednesday, July 25, 2012 1:17 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Do not display a form if the control source (a query) return no rows
>
> Hi Crystal,
>
> So I still have to check if there is something to be displayed on the form and then do something.
>
> There is no quick and easy way of checking if zero row is return or something like that.
>
> Regards,
> Thomas
>
> --- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@> wrote:
> >
> > Hi Thomas,
> >
> > the Form OPEN Event has Cancel
> >
> > Warm Regards,
> > Crystal
> >
> > Learn Access on YouTube
> > http://www.YouTube.com/LearnAccessByCrystal
> >
> >
> > Â *
> > Â Â (: have an awesome day :)
> > Â *
> >
> >
> >
> > ________________________________
> > From: Thomas <thomas_lam_us@>
> > To: MS_Access_Professionals@yahoogroups.com
> > Sent: Tuesday, July 24, 2012 5:40 PM
> > Subject: [MS_AccessPros] Do not display a form if the control source (a query) return no rows
> >
> > What is the event which will be fired under this condition? Can I display a message box and then issue the CANCEL = TRUE to suppress the form from displaying?
> >
> > Regards,
> > Thomas
> >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar