The wizard just writes VBA code for you; you can write the code yourself if
you prefer.
I don't think it's within the limited abilities of macros -
and frankly I can't imagine why you'd want to limit yourself to macros
instead of using VBA coding.
I can't think of any way of using SQL -
AFAIK SQL is used to define recordsets, or to manipulate data in tables,
but not to move between records in a recordset which is already defined.
HTH
- Turtle
"lynnepig" <lw*****@yahoo.com> wrote in message
news:42**************************@posting.google.c om...
i have seen the question several times regarding how to use a combo
box in a form to find a record, but the answers always reference using
the wizard or VB. i'm wondering if it can be done without using
either of those--macros and SQL would be fine.
thanks.