About absoluteposition

[richard.iserman]

This question will take a bit to explain, but it's actually very
simple.

I have a table that keeps track of business unit numbers and
accompanying bill codes. There may be multiple records of the same BU
but each BU has only one bill code.
An accompanying form displays the BU in a textbox, and the bill code
in a combo box, which is fed from a query that returns all of the
available bill codes for the specified BU.

I would like to set the AfterUpdate property of the combo box go to
the record of a bill code after it is selected.
Based on my reading thus far, it seems the best way to do this is to
query the query that feeds the combo box and get the absolute position
of the record that matches the bill code that is selected in the combo
box. Trouble is, I have no idea how to do this.

I appreciate any help that you can offer on this.
Thanks

Richard

 

[Albert D. Kallal]

If you form is based on the same table, then the combo box wizard will build
you a combo box, and when you select a value from the combo box, the form
will move to that record...


Have you tried the combo box wizard?