Go to

Hello,

I would like to go to the next unused record automatically when I open a
form (hopefully from the switchboard). I have a database that keeps track of
product numbers. We are assigned a lot of about 500 product numbers every
few months and I would like to load those to the database and then as we add
new products mark them used. How can I go to the next unused prodcut number
when opening a form? (I am hoping that I don't have to use coding, but that
would be ok if it is the only way.)

Any info I can get to point me in the right direciton would be helpful.

Thanks much,

Stephanie

"steph44haf" wrote in message

Hello,

I would like to go to the next unused record automatically when I
open a form (hopefully from the switchboard). I have a database that
keeps track of product numbers. We are assigned a lot of about 500
product numbers every few months and I would like to load those to
the database and then as we add new products mark them used. How can
I go to the next unused prodcut number when opening a form? (I am
hoping that I don't have to use coding, but that would be ok if it is
the only way.)

Any info I can get to point me in the right direciton would be
helpful.

Thanks much,

Stephanie

You could just base the form on a query that returns only the unused
product numbers, or else apply a where-condition when opening it (e.g.,

DoCmd.OpenForm "frmProductNos", _
WhereCondition:="Used=False"

), and thus have the form only show unused product numbers. As far as
what constitutes the "first" unused number, that depends on the way your
product numbers are set up, but it may very well be that having the
form's recordsource query sort ascending on product number will do it.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

I never thought of that. I will give it a try. Thanks!

"Dirk Goldgar" wrote:

"steph44haf" wrote in message

Hello,

I would like to go to the next unused record automatically when I
open a form (hopefully from the switchboard). I have a database that
keeps track of product numbers. We are assigned a lot of about 500
product numbers every few months and I would like to load those to
the database and then as we add new products mark them used. How can
I go to the next unused prodcut number when opening a form? (I am
hoping that I don't have to use coding, but that would be ok if it is
the only way.)

Any info I can get to point me in the right direciton would be
helpful.

Thanks much,

Stephanie

You could just base the form on a query that returns only the unused
product numbers, or else apply a where-condition when opening it (e.g.,

DoCmd.OpenForm "frmProductNos", _
WhereCondition:="Used=False"

), and thus have the form only show unused product numbers. As far as
what constitutes the "first" unused number, that depends on the way your
product numbers are set up, but it may very well be that having the
form's recordsource query sort ascending on product number will do it.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)