Results 1 to 5 of 5
  1. #1
    m.gomez36 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    4

    Angry Combo Box issue in Forms

    I'm having trouble getting my combo boxes (cb) to work. I cannot get my boat cb to use the correct information. The vehicle cb lookup works great and I have no problem but I cannot seem to get the boat cb to work at all. I have a seperate tables for boats and vehicles, I am also building the form to work with another table that they both share. Where would be a good place to start???


    Click image for larger version. 

Name:	combo.png 
Views:	9 
Size:	19.1 KB 
ID:	13508

  2. #2
    m.gomez36 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    4
    This is the pop-up I receive when I try to select the cad#...
    Click image for larger version. 

Name:	combo1.jpg 
Views:	7 
Size:	28.8 KB 
ID:	13509

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    Based on the error, the value returned by the combo's row source is text, and the data type of the field in the control source is numeric (or that type of issue).
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    m.gomez36 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    4
    Found the problem... but did I fix it correctly? The column count was @ 1 on there was not column width.
    Click image for larger version. 

Name:	combo2.jpg 
Views:	6 
Size:	26.2 KB 
ID:	13512

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    It appears that combo should only have a column count of 1, with the corresponding column widths and bound column properties.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Perplexing forms issue
    By Wildanessdude in forum Programming
    Replies: 9
    Last Post: 02-06-2013, 07:58 AM
  2. Forms text box issue
    By shree in forum Forms
    Replies: 27
    Last Post: 05-17-2012, 01:20 PM
  3. Issue w/ VBA code for Opening/Closing Forms
    By need_help12 in forum Forms
    Replies: 5
    Last Post: 04-20-2012, 11:09 AM
  4. multi forms open & focus issue
    By tfulmer in forum Programming
    Replies: 1
    Last Post: 08-23-2011, 04:00 PM
  5. Need help with query table issue using forms
    By KLynch0803 in forum Access
    Replies: 1
    Last Post: 06-02-2009, 10:40 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums