Access 2003

[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

 

[Al Campagna]

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."

 

[Jacob]

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?

 

[Jacob]

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?

 

[Al Campagna]

Jacob,
Private Sub cbo1_GotFocus()
Me.YourcboName.Dropdown
End Sub
--
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."