find and edit records in forms

Z

ZahiR

i cand add new record or look up records via my form, and i know there is a
way that you can look up a record by any selcted field, say part number, and
after typing that in msg box, that part number and all its relevent fields
come up on your form--just as you had went to a next record or had scroled
through, but nothing i can see in controls of access does that, wouldn't this
be a very vary vary first thing a database would have as its built-in
function? when ever i ask help for this on the web or access help, it comes
with list box or combo or scrolling around, this ain't a pretty pictures if
you have thousands of records to flip through...am i just too unfamiliar with
access or this very useful tool is hidden from new users, or you have to code
or macro out you way??? don't you guys agree search by any field and then
once typed in by user, the whole form be populated by data? please let me
know if i am just too stupid or access forgot the big picture? thanks, zahir
 
N

NetworkTrade

Forms can do it - or Forms can prevent you from doing it - - - since a Form
is used to control how the end user deals with the data.

If you are the admin on this or otherwise can go to the tables themselves
then of course the quick & dirty is to sort the column you want there.....but
in some work environments this approach is a no-no.

But via Form you can put in combo boxes for all the fields - and then as you
enter info it will pull up the record corresponding to what you are typing as
you enter it letter by letter....most people just put in the first few
letters and then use the pull down of the combobox to highlight which entry
is desired.

Some older versions of Access and current version that are not fully up to
date with all components or are not legally licensed don't autocomplete your
typing and so possibly this is the symptom you are experiencing.... it is
possible the autocomplete is an option that can get turned on/off though I
can't remember at the moment as it works for me all the time......
 
Top