Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Northern, NJ, New Jersey, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SubForm Data Linked to Mainform...

    I will do my best to explain this one...

    I have a form with a subform. The form has a combo box that has a column count of 2 [store name] and [id]. The subform needs to display the [id] after the [store name] is selected in the combo box.

    The Row Source for the combo looks like this:
    SELECT [Stores].[Store Name], [Stores].[ID] FROM Stores ORDER BY [Stores].[Store Name];

    I can get the store name to display as it does in the combo, but I need the id to display.

    Any thoughts at all!?
    There is always a way.

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SubForm Data Linked to Mainform...

    Try opening the form in design view and select the combo box and right click to see the properties. Go to the formatting tab and check to see if the column widths are something like 0";1". Change the zero to say, 1" or .5" and save it and see if the ID shows up on the form.

Posting Permissions

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