Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by tomcone

  1. tomcone

    In Access, How set object to SQL Select Statement

    I want to have an On Change event which sets an unbound field in the subform to be the equal to the result of a SQL Select query. What is the VBA code to say: UnboundCntrol= Select .. from ... where ...; I keep getting compile errors on my attempts. Thx
  2. tomcone

    Requerying subform combo box based on changing value in main form

    Will give it a try. Also I want to set an On Change event which sets an unbound field in the subform to be the equal to the result of a SQL Select query. What is the VBA code to say: UnboundCntrol= Select .. from ... where ...;
  3. tomcone

    Requerying subform combo box based on changing value in main form

    In a form called Boxes, there is a combo box called MasterBox. In a continuous subform Files, there is a combo box FileName which uses MasterBox in the criteria for its query to lookup only files that are in MasterBox. I want to use the original value of MasterBox when entering the first few...
  4. tomcone

    Refresh control on a form

    Did you get it to work, I think I am having the same problem you are having.
See more

Part and Inventory Search

Back
Top