Results 1 to 5 of 5
  1. #1
    clarkproperties is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Aug 2020
    Posts
    7

    Combo box problem


    I have a sub form with a combo box that works when the subform is open by its self
    Click image for larger version. 

Name:	2020-10-09.png 
Views:	22 
Size:	105.7 KB 
ID:	43160

    But when i get to the main form it wont work
    Click image for larger version. 

Name:	2020-10-09 (1).png 
Views:	21 
Size:	91.7 KB 
ID:	43161

    What am i doing wrong if you select by product name it works but not by Part Number

    thanks
    Steve

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    You need to look at the row source of the combo and make sure any references to controls on it are done at the subform level:
    http://access.mvps.org/access/forms/frm0031.htm

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  3. #3
    clarkproperties is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Aug 2020
    Posts
    7
    Here is my row source I a novice at this

    SELECT [Products].[Part Number], [Products].[ProductName] FROM [Products];

  4. #4
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Can you post a copy of the db
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  5. #5
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,860
    Am I missing something here?

    Your first form uses Product Name and populates Unit Price and possibly Extended price using the Quantity?
    The second is using Part Number and does nothing.?

    The query for both would be different I would have thought unless you move the bound column?, plus we have no idea as to what the source is for those other controls on the second form.?

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

Similar Threads

  1. combo box problem
    By Johnny Chow in forum Access
    Replies: 4
    Last Post: 12-24-2018, 09:31 PM
  2. Combo Box Problem
    By dccjr in forum Access
    Replies: 2
    Last Post: 11-13-2012, 09:48 PM
  3. Combo box problem
    By corystemp in forum Access
    Replies: 3
    Last Post: 06-24-2010, 09:47 AM
  4. Combo Box problem
    By Rick West in forum Forms
    Replies: 3
    Last Post: 03-18-2010, 04:42 PM
  5. Combo box look-up problem
    By Samdaman in forum Forms
    Replies: 0
    Last Post: 12-14-2009, 02:54 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
  •  
Other Forums: Microsoft Office Forums