Results 1 to 4 of 4

Thread: DLookups

  1. #1
    Join Date
    Aug 2006
    Posts
    27

    Unanswered: DLookups

    From a bound subform, based on an entry, I need to read multiple records from a seperate table and update those records. Since it is a bound form, I can't open a recordset(or can I?) and I can't do multiple dlookups(Or can I?) based on a query. I'm probably overthinking this. Any help is appreciated.

  2. #2
    Join Date
    Jan 2007
    Location
    California, USA
    Posts
    520
    You can do both things you asked. A bound form (or subform) just means that the form is taking care of retrieving data and re-writing it when the user changes data. So you can open as many recordsets and use as many DLookups as needed. But remember, "All things in moderation."
    Hope this helps,

  3. #3
    Join Date
    Aug 2006
    Posts
    27
    I must have had something wrong with my recordset code. I usually use ADODB. Do you have to use DAO? I always get a user defined error when I try to use DAO.

  4. #4
    Join Date
    Jan 2007
    Location
    California, USA
    Posts
    520
    Where does the question about DAO or ADO come from? You can use either to create a recordset, and if you are used to using ADO, I see no reason to switch to DAO. If I have missed something here, please let me know what it is.
    thanks,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •