Combo Box Display in Form

[rachello89]

I have a form that displays a client's products they have purchased. The form is also used to add new products. The field where they select a product is a combo box. I want to set up a query that only allows the drop-down to show products that are active. But when I set that up in the combo box's query, previous products they purchased that are now inactive will not display. It just shows a blank field. Thanks in advance for your help!

[June7]

You have the form in datasheet or continuous view? That is a known issue with conditional comboboxes/listboxes in those views. I don't know any solution other than to display the value in a textbox.

[Missinglinq]

There's probably another way to do this, but like June7, I don't know it! This is a step-by-step I've posted before for others in your same situation:

• In Form Design View, Right Click on your Original Combobox
• Click on Change To
• Click on Textbox
• Right Click on your Original Combobox/Now Textbox, again
• Click on Properties
• Click on Other
• Change the Name Property to ProductTextbox

• Now, create a New Combobox, setting its RowSource to your new Query that excludes inactive products
• Right Click on your New Combobox/[B]
• Click on Properties
• Click on Other
• Change the Name Property from the name Access gave it to NewProductCombo
• Leave this Control Unbound, i.e. leave the Control Source blank

Now place this code in the Form's Code Module:

Private Sub NewProductCombo_AfterUpdate()
 Me.ProductTextbox = Me.NewProductCombo
End Sub

Private Sub Form_Current()
 Me.NewProductCombo = Null
End Sub

Linq ;0)>