Need to get to a specific record

Need to get to a specific record

am 16.04.2008 10:29:07 von themastertaylor

I have a system for placing orders with suppliers, when i'm checking
invoices I need to get to specific orders and ammend quantities prices
etc. When i place an order i have a nice form for the data input.
what i ideally need is to find a way to use this form to get to a
specific record. I know that you can click through the records
however the record number and the order id aren't the same, as such at
present i have to do a bit of guess work. i.e. if i want to get to
order 2947 i need to guess which record number it is and hopefully get
near.

i'd rather not produce a parameter query as i'd need to rebuild my
form to take reference from the query, which would mean recoding
comboboxes and other features i have on there.

Ideally i need something like the find feature in word, so that i can
open my form in edit mode, hit find enter the order number and go
straight there - is this possible?!

Re: Need to get to a specific record

am 16.04.2008 15:39:44 von burnspaul

Add a command button to your form selecting Record Navigation and Find
Record. If you click into your ID field before clicking your find
button you will be able to search this field only. Hope this helps

Re: Need to get to a specific record

am 16.04.2008 15:51:25 von Tom van Stiphout

On Wed, 16 Apr 2008 06:39:44 -0700 (PDT), Paul
wrote:

Or simply set focus to the field and hit Ctrl+F for the Find dialog.
-Tom.


>Add a command button to your form selecting Record Navigation and Find
>Record. If you click into your ID field before clicking your find
>button you will be able to search this field only. Hope this helps