Page 2 of 2 FirstFirst 12
Results 16 to 22 of 22
  1. 12-27-2009, 03:17 PM #16
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917

    The property is on the Data tab of the ComboBox.
    Reply With Quote Reply With Quote
  2. 12-27-2009, 07:20 PM #17
    darksniperx
    darksniperx is offline Novice
    Windows 7 Access 2003
    Join Date
    Dec 2009
    Posts
    24
    Sorry I haven't noticed the second page.

    " As soon as I change bound column to any other number than 1, ms access crashes.
    "
    Reply With Quote Reply With Quote
  3. 12-27-2009, 08:11 PM #18
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    Me too, so I changed the AfterUpdate events in both.
    Reply With Quote Reply With Quote
  4. 12-27-2009, 08:39 PM #19
    darksniperx
    darksniperx is offline Novice
    Windows 7 Access 2003
    Join Date
    Dec 2009
    Posts
    24
    Thank you very much, works like a charm.

    the changes that were made are the following if I am correct.


    1. Bound to column 2
    2. limit to list no
    3. Dim rs As DAO.Recordset
    Reply With Quote Reply With Quote
  5. 12-27-2009, 08:48 PM #20
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    AND I used RecordsetClone and not Recordset.Clone
    Reply With Quote Reply With Quote
  6. 12-27-2009, 08:50 PM #21
    darksniperx
    darksniperx is offline Novice
    Windows 7 Access 2003
    Join Date
    Dec 2009
    Posts
    24
    ok, thank you. Learn something new everyday.
    Reply With Quote Reply With Quote
  7. 12-27-2009, 09:19 PM #22
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    You're welcome. Are you ready to follow the link in my sig and mark this thread as Solved?
    Reply With Quote Reply With Quote
Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. VBA Code To Work With MySQL
    By botts121 in forum Programming
    Replies: 0
    Last Post: 07-08-2009, 08:51 AM
  2. Headcount query for several months - HELP to get it to work
    By kcam2001 in forum Queries
    Replies: 0
    Last Post: 02-27-2009, 01:39 PM
  3. Forms don't work the same
    By hawzmolly in forum Access
    Replies: 0
    Last Post: 12-18-2008, 05:46 PM
  4. Can't get TransferSpreadsheet to work
    By Valeda in forum Import/Export Data
    Replies: 0
    Last Post: 07-19-2007, 08:04 AM
  5. Nested IIf query will not work
    By ddog171 in forum Queries
    Replies: 1
    Last Post: 06-20-2006, 02:03 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums