Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005
    Posts
    1

    Setting combo box properties

    I am trying to set a combo box row source with a query and define the bound coulmn to column 1. I cannot seem to make the code work. could someone please provide some guidance. I have supplied the "on click" event procedure for the button to open the form. I believe the bound column defaults to "1" but I am not sure if I need to set it with code to 1.





    DoCmd.OpenForm "frmCarneysPointSafetyValveData", acNormal
    DoCmd.ApplyFilter , "Plantnumber = '872'"
    forms!frmcarneyspointsafetyvalvedata!combo107.rows ourcetype = "SELECT qrySafetyValveFilter.Tag FROM qrySafetyValveFilter WHERE (((qrySafetyValveFilter.PlantNumber)="872")) ORDER BY qrySafetyValveFilter.Tag;"


    DoCmd.Close acForm, "FrmCarneysPointPlantInformationPage"

    Thanks

  2. #2
    wazz is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Dec 2005
    Location
    Vancouver
    Posts
    2

    Re: Setting combo box properties

    Quote Originally Posted by rathfam4
    I am trying to set a combo box row source with a query
    have you tried creating and saving a query and simply making the rowsource = qryYourQueryName?

    btw: i think it's rowsource not rowsourcetype in your code. try opening the form and setting the rowsource of your combobox to a query.

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

Similar Threads

  1. Setting a field to be dependent on another
    By CushingMT in forum Forms
    Replies: 0
    Last Post: 11-19-2008, 11:51 AM
  2. Setting criteria in a calculated date field
    By SteveReberger in forum Access
    Replies: 0
    Last Post: 10-29-2008, 06:58 AM
  3. Replies: 0
    Last Post: 08-17-2008, 12:19 PM
  4. Displaying Query Properties in a Form
    By Bjar in forum Programming
    Replies: 1
    Last Post: 07-16-2008, 07:51 AM
  5. problem setting Excel sheet name in vba from a form
    By dataman in forum Programming
    Replies: 2
    Last Post: 04-18-2006, 07:26 AM

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