'Jump to' record selector

R

rico

I have a table with many records (1500). On my form which displays these
records i was trying to figure out a way the user could jump to a particular
record. Maybe a button on the form which would bring up a popup in which they
enter a value which would show which record they want.

[serailno] is the primary field the user would enter to bring up a specific
record record.

Many thanks for any help

enrico
 
R

rowiga

Add a combo box to the form header (or footer) that allows the user to pick
the record they want to view. You can use the wizard to help you create the
combo box. Select that you want the combo box to look up a specific record
within the wizard.
 
D

dsoffe

Won't the find command ( Ctrl + f ) work? If your cursor is in the
serialno field of your form when you do the ctrl + F, it will even default to
searching that field.

rowiga said:
Add a combo box to the form header (or footer) that allows the user to pick
the record they want to view. You can use the wizard to help you create the
combo box. Select that you want the combo box to look up a specific record
within the wizard.

rico said:
I have a table with many records (1500). On my form which displays these
records i was trying to figure out a way the user could jump to a particular
record. Maybe a button on the form which would bring up a popup in which they
enter a value which would show which record they want.

[serailno] is the primary field the user would enter to bring up a specific
record record.

Many thanks for any help

enrico
 
Top