Thanks that worked well. This method selects only one record from the
db, because Im searching a primary key. How do I go about getting all
the records but focused on the searched record?
Thanks.
> Thanks that worked well. This method selects only one record from the
> db, because Im searching a primary key. How do I go about getting all
> the records but focused on the searched record?
To accomplish what you want, we will now NOT restrict the records loaded,
but "move" the forms pointer to the record we want.
We can use:
docmd.Openform "frmProducts"
forms!frmProducts.RecordSet.FindFirst "id = " & me.id
I as a general rule remove navigation buttions, and load the form to ONE
record (no need to load up more data then the user needs).
However, the above should do the trick for you...

Signature
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal