Search results

  1. K

    The value selected in a combo box is not what shows up

    I have an unbound combo box that I populate using the following query: SELECT Customers.PartnerID, Customers.CustName FROM Customers WHERE (((Customers.PartnerID)=[Forms]![Partners-Detail]![Master_ID])) ORDER BY Customers.CustName; I get the correct values displayed when I hit the drop down...
  2. K

    How to reference a field on a subform on a tab control?

    As best I can tell my form has the following hierarchy of controls. As you go down the list, the item below is a child of the item above it. Form - Partners-Detail Tabcontrol - TabCtL6 Page - Interactions Subform - Contract_Detail subform Combo Box - Customer How would I reference the combo...
  3. K

    Clear an unbound field on a form

    Is there a way to clear an unbound field on a form from a macro? My form takes input from unbound fields and appends that data to a table. I want to clear those fields and requery the DB after the append from a button. Is there a way to do this without VB code (I'm not great at VB)? Thanks...
  4. K

    Datasheet with entry at the top

    I have a datasheet that has a list of interactions with a partner in reverse date order (Newest on top). I did this because I didn't want to scroll to the bottom each time to get the latest interaction. How can I enter a new interaction without having to scroll to the bottom of the datasheet...
  5. K

    How to filter the contents of a combo box based on a field in a form

    I have a combo box that allows a user to select the name of a partner contact. The combo box should only have those partner names that match the partner that I am currently viewing. I can get the combo box to either display all values in the contacts table or I can get it to just show the...
Back
Top Bottom