Is there anything wrong with this code....

  • Thread starter Thread starter Mary Hartman
  • Start date Start date
M

Mary Hartman

I created a combo in a form to look up a field (products_model) in a
table and then go to that record in the form. When I put it together
in my practice database, it worked just fine.

Now that I have put it in my finished product, it just sits there. Is
there something wrong with this code that I can't see?

Private Sub cboFindProduct_AfterUpdate()

DoCmd.GoToControl "products_model"
DoCmd.FindRecord cboFindProduct
DoCmd.GoToControl "inventory_id"

End Sub

It's driving me craaaaaazy!!! :>(
 
Mary,

The first thing I would check is that the cboFindProduct combobox might
be multi-column, and if so, ensure that its Bound Column is the
products_model field.

Other possibilities, such as the control not being named the same as the
products_model field, or not being visible, or enabled, would result in
error messages... unless error handling in your code bypasses them, that is.
 
Back
Top