Results 1 to 7 of 7
  1. #1
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    528

    combo box for Subform

    Hello all
    I'm working combobox16 for Subform
    It works well on the subform
    But it seems to me an error in the main form


    This is an example of the database
    Any help
    Attached Files Attached Files

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    The Combo1 on the tblmas Form is switching the RecordSource of the MainForm from the tblmas table to the Table1 table. The field names are different so I'm not sure what you are expecting.

  3. #3
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Thank you very much rural
    I just want to work to filter subform
    On the basis of a certain value, such as the date or category
    But I want to be a combo box in the main form
    And not in the subform
    Is it possible that?

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    You can sort of do that with the LinkMaster/ChildFields properties on the SubFormControl.

  5. #5
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Thank you very much
    But how?
    Is it possible amendment to an annex

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    The translator you are using spits out some really weird sentences. You can have more than one LinkMaster/ChildFields argument by separating them with a ";". I'm not real sure what you are trying to accomplish but it may be that you don't want to use the LinkMaster/ChildFields properties at all. They filter but not the way you are describing.

  7. #7
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    I'm going to try and take this off line for a bit for some concentrated assistance.

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

Similar Threads

  1. Replies: 5
    Last Post: 12-11-2013, 08:15 AM
  2. subform combo box
    By char in forum Access
    Replies: 1
    Last Post: 11-13-2012, 02:39 PM
  3. Replies: 33
    Last Post: 01-13-2012, 07:44 AM
  4. Replies: 5
    Last Post: 01-02-2011, 10:09 AM
  5. Replies: 0
    Last Post: 08-17-2008, 12:19 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