Upon Enter, update form to new value

  • Thread starter Thread starter js
  • Start date Start date
J

js

I have a field on a form that contains the number of a fire hydrant. It is
the primary key. I'd like to be able to type another value in that field
(lets say "FHCH-005) and have the form move to that record so I can view the
info for that hydrant.

Being 3 minutes before the end of the day and not knowing much about visual
basic:

Private Sub Number_Enter()
DoCmd. GoToRecord? or FindRecord?

Thanks for any advice.

TGIF
 
Personally, I would add a combo-box to the form header and name it "Find:".
The combo-box wizard will offer you the options of "finding a record and
moving to it".

The wizard will do all the work for you.
 
Thanks, I guess I'll have to study up a bit on the toolbox. I didn't know
this capability existed.
 
Back
Top