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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sandbolt

    synchronized combo boxes not working when subform

    Thanks for all of your help. Didn't get a chance to try it, but will soon.
  2. sandbolt

    synchronized combo boxes not working when subform

    RowSource:qryHVECustNum This is the query: SELECT DISTINCT tblBillingData.[CUSTOMER NUMBER], tblBillingData.CUSTOMER FROM tblBillingData WHERE (((tblBillingData.CUSTOMER)=[forms]![frmHVESub]![Customer]) AND ((tblBillingData.ACCOUNT)="452470" Or (tblBillingData.ACCOUNT)="452471")); I tried...
  3. sandbolt

    synchronized combo boxes not working when subform

    I have a form with synchronized combo boxes in a subform. They work when I open the subform by itself to enter data. When I open the main form, then tab down to the subform, the second combo box does not get updated. I get prompted for the value in the first combo box; as if the query cannot...
  4. sandbolt

    help with query using start and end dates

    Awesome! Thanks for your help.
  5. sandbolt

    help with query using start and end dates

    PHV, Thanks. It worked when I entered Assignment End Dates for everyone. Any idea how to make it work if end dates are left blank?
  6. sandbolt

    help with query using start and end dates

    Hi, I need to create a query that assigns salesreps to customers billing data. The assignment table includes: Customer Rep Assignment StartDate Assignment EndDate A customer can only have one rep assigned to it at a time. The sales data includes Customer Period (month in which sales occurred)...

Part and Inventory Search

Back
Top