ACCESS FEED: [MS_AccessPros] Re: No Data when split form opens

Rabu, 22 Mei 2013

[MS_AccessPros] Re: No Data when split form opens

LOL. I've others do the same thing so I guess we are in good company.

Doyce

--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> Doyce
>
> Same thing happens to me. Sometimes I just have to verbalize a problem and I get the "ah-ha!" moment.
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com, "dnwinberry" <winberry.doyce@> wrote:
> >
> > You're welcome Bill. It happens often that right after I send a request for help, I think of something else to try that often works. :-) Perhaps just stating the problem helps my brain come up with a solution. Thanks to all you pro's who are out there helping us!!
> >
> > Doyce
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@> wrote:
> > >
> > > Doyce-
> > >
> > > Thanks for letting us know you solved the problem.
> > >
> > > Bill
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, "dnwinberry" <winberry.doyce@> wrote:
> > > >
> > > > I think I've solved my own problem. I put Me.requery in the forms load event and it works as I want.
> > > >
> > > > Doyce
> > > >
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com, "dnwinberry" <winberry.doyce@> wrote:
> > > > >
> > > > > Hello all,
> > > > >
> > > > > I have created my first split form. I'm using Access 2010. This form is based on a query that filters records by the date in a text box on the form with the default value of Date(). However the form opens without showing any records and I'd like for it to open with records dated today. In the after update event of the date text box, I have Me.requery which populates the form with the correct records. I just can't get it to open with today's records even though the text box opens with today's date in it. Please help. Here is the SQL of the form's record source:
> > > > >
> > > > > SELECT tblUntaggedUnits.UnitID, tblUntaggedUnits.CustID, tblUntaggedUnits.BuildDate, tblUntaggedUnits.InspectionComments, Customers.[Cust Name]
> > > > > FROM Customers INNER JOIN tblUntaggedUnits ON Customers.[Cust ID] = tblUntaggedUnits.CustID
> > > > > WHERE (((tblUntaggedUnits.BuildDate)=[Forms]![frmUntaggedByDate]![txtDate]));
> > > > >
> > > > >
> > > > > Thanks,
> > > > > Doyce
> > > > >
> > > >
> > >
> >
>