Results 1 to 2 of 2

Thread: SQL question

  1. #1
    Join Date
    Feb 2015
    Posts
    1

    SQL question

    I have a table Customer Complaints with a field BSICustomerName it is a combo box field with a query attached to it. It looks to the Customer Information table to select the customer name. When i select the customer name from the Customer Information table i want to also populate the BSICustomerID field on the Customer Complaints form with the CustomerID from the Customer Information table. It can be either automatic or after I select BSICustomerName and then click on the menu for BSICustomerID the correct ID is the only option available. Any help would be appreciated.

    Thanks...

  2. #2
    Join Date
    Jan 2015
    Location
    Birmingham AL - USA
    Posts
    7
    the combo box control's query can have multiple fields - even if they are intentionally not visible. You can refer or call these values by their column - or - you can write these values ...

    if you call the value then you use an unbound text field and enter its record source as: =Me.ComboboxName.column(2) .....hopefully it is obvious that I just made up the column count as 2 and you would put in the correct value.

    if you need a permanent record of that value then you need to write it into a bound text box; in which case in the AfterUpdate Event of the ComboBox you would put: me.SomeTextFieldName = me.ComboBoxName.column(2)

    Hope this helps you figure it out....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •