subforms

[Natasha]

Hi Steve

I did what you said and now the cooler info comes up automatically, but the
company info that came up before automatically on the main form doesn't come
up now.

Natasha

Natasha,

If you want to use a combobox like this for navigation purposes, it will
need to be an *unbound* combobox.

One way you can do it is like this:
- with the existing combobox, remove the Control Source being CustomerID
- rename the existing combobox, let's say you name it CustFind
- put a textbox on the form, name it CustomerID, and put its Control
Source to CustomerID
- on the After Update event of the unbound combobox, put code like this...

Me.CustomerID.SetFocus
DoCmd.FindRecord Me.CustFind
Me.CustFind = Null

Was this post helpful to you?

Why should I rate a post?



Expand AllCollapse All

Manage Your Profile |Contact us
© 2006 Microsoft Corporation. All rights reserved. Terms of Use |Trademarks
|Privacy Statement