'Jump to' record selector

[Guest]

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

 

[Guest]

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.

 

[Guest]

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.

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.

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