Auto-select next record alphabetically

  • Thread starter Thread starter kevinhay
  • Start date Start date
K

kevinhay

Hi, all!

Here's the situation:

I have someone entering work hours into a form from a sheet that lists
them alphabetically. To save LOADS of time, she needs to have the form
automatically select the next alphabetical record as soon as she adds
the current record. I've already got a query setup that selects the
employees alphabetically for the Employee combo box. I'm thinking I
just use this query as the record source and somehow use Recordset
programming to select the next record in the query. THE PROBLEM is
that I'm not up to snuff with recordset programming yet. I'm not even
sure whether I need to use DAO or ADO.

Can anyone help or at least point me in the right direction? I figured
I'd go ahead and post here as well as try to find something on my own.
I'm sure I'll have better luck here. :-)
 
kevinhay said:
I have someone entering work hours into a form from a sheet that lists
them alphabetically. To save LOADS of time, she needs to have the form
automatically select the next alphabetical record as soon as she adds
the current record. I've already got a query setup that selects the
employees alphabetically for the Employee combo box. I'm thinking I
just use this query as the record source and somehow use Recordset
programming to select the next record in the query. THE PROBLEM is
that I'm not up to snuff with recordset programming yet. I'm not even
sure whether I need to use DAO or ADO.
Click to expand...


What is the form's Record Source? It should probably be a
query with a sort specified for whatever field you want to
be in alphabetical order. However, I am having trouble
imagining how selecting "the next alphabetical record" ties
into adding new records???

As for DAO vs. ADO, if you using the Jet database engine (or
if you don't even know what that is), then you should be
using DAO. If you're using MSDE, SQL Server, Oracle, etc.
then you might want to use ADO.
 
Back
Top