Sue,
There is no such thing as a 'row number' in a table more so
than if there are ordered pieces of popcorn in a bowl. Every
record should have a distinct unique ID field, but it is not
the job of a table to keep these in a specific order.
As to your combobox issue, I believe that it is actually the
ID that is being put in the table, not the row number. This
is fairly normal behaviour for well designed databases. For
example, if your combo was displaying Products, every
product should have an ID and that is what should be stored
rather than the ProductName. If you have a Products table
with an ID field and a Name field, you just pull in the Name
down the road in a query to base forms and reports on as
needed.
I have a feeling that you created this combo with the wizard
and didn't notice the 'Hide Key Field' that was checked by
default as you built it. If this is the case, it is because
the wizard made the first column have a zero length width,
effectively hiding it. Now you type in and get the product,
but it is really the ID that you selected.
If you really do want to save the name, you will probably
need to change the BoundColumn property to '2' instead of
the '1' it is probably set on. Look at the ControlSource and
make sure it is set on the appropriate field as well.
--
Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
