Access 2003

  • Thread starter Thread starter Jacob
  • Start date Start date
J

Jacob

Looking for code help.

I have an access 2003 Inventory DB. In it I have a main equipment form where
you can add and remove equipment from the inventory. What I would like to do
is add a drop down to select a record to go to (Based on Primary Key). I
have tried all I know on the list box's AFTER UPDATE event to get the form
to navigate to the selected record. Can anyone offer me a word of advise?


JAS
 
Jacob,
On my web site (below), I have a sample 97 and 2003 called Combo Quick
Find, that demonstrates using a combobox to GoTo a specific record.
In your case... it would allow the user to select a record by equipment
name (or some meaningful field), but really does the Find by the Primary
key.

--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
I am having difficulty getting this to work on the line where I am trying to
FINDRECORD ID.
I cant quite seem to make it work for the AUTO number field....any
suggestions?
 
I got it figured out...WHEW! Must have been a blond moment. Is there a way
to make the list box drop down when it has focus?
 
Back
Top