Search results

  1. D

    Drop down box in a form to call a query

    In the combobox, the text of "IT Stock" is selected. If I do: msgbox me.combo7 I get a value of 1, but I want it to say IT Stock
  2. D

    Drop down box in a form to call a query

    Hi, That did send me in the right direction, but I do not understand how to reference the combo box. I use this: doCmd.OpenForm "stockcheck2", , , "devicestatus = '" & Me.Combo7 & "'" devicestatus is a column in stockcheck2 when viewing the data as a table
  3. D

    Drop down box in a form to call a query

    Hi, I am sure you guys and girls know exactly how to do this, but I am stuck. I want to track which user has which phone and track issues with them. I have all the relationships set up right. I have tables: DeviceStatus - for the drop down box, contains IT Stock, Faulty, With User and...
Back
Top Bottom