Search results

  1. A

    Question Refresh Form Data

    The = doesn't make a difference, still not clickable. Still not populating fields.
  2. A

    Question Refresh Form Data

    Ahah! my Control Source was "Vendor" when the table name is "Vendors" so I changed it so it now reads "=[Vendors]" This may have fixed it, but now upon clicking any of the drop down choices nothing happens, is this because my OnClick Event is blank? Private Sub Vendor_Click() End Sub...
  3. A

    Question Refresh Form Data

    "Make sure that the combo is bound to the correct column." Does that mean the Row Source of the combo box? SELECT [Vendors].[VendorID], [Vendors].[Vendor Name] FROM Vendors ORDER BY [Vendor Name]; "Vendors" is the name of the table... so I mean that should be right. I deleted all the macros...
  4. A

    Question Refresh Form Data

    I thought that my record source is already a query that gets data from the vendor table, otherwise how would it get that data? Like so: SELECT [Purchase Orders].*, Vendors.[Contact Name], Vendors.[Contact Name], Vendors.[Vendor Name], Vendors.Address, Vendors.City, Vendors.[Zip Code]...
  5. A

    Question Refresh Form Data

    Hello, I am working on a Purchase Order database in Access 2010 for a small company. I have a purchase order form which gets data from the vendor table. So when a user selects a vendor from the combo box, I want the corresponding information (vendor phone #, address, etc.) to display in the...
Back
Top Bottom