Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Re: DAO Information for newbies

Discussion in 'Information Technology' started by Dirk Goldgar, Jul 28, 2006.

  1. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse

    "HK" <Harlan.Koehn@gmail.com> wrote in message
    > I sure appreciate the help here. I'm a very inexperienced programmer
    > and I don't reference the DAO object at all. My code typically looks
    > like:
    > My.Recordsource = "Select * from tblNewbie"
    > Me.Requery
    > I do like the input I'm getting. Thanks and keep it coming.

    That code doesn't use DAO *or* ADO at all; at least, not directly.
    There, you're manipulating an object that is defined by Microsoft Access
    itself: the Form object. (But "My.Recordsource" is likely to be a typo,
    and should be "Me.RecordSource".)

    Note, by the way, that when you change a form's RecordSource property,
    there's no need to requery it. Access automatically requeries the form
    when you change its recordsource.

    Dirk Goldgar, MS Access MVP

    (please reply to the newsgroup)
  2. Loading...

Share This Page