Find Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please forgive me for my limited knowledge of Access 2003. I would like to
know how I can look up a record on a form then select that record and edit
it. I would like to have one form that allows me to search then if the
record is there I can select it and it takes me to a subform for data entry
purposes. If the record does not exist then I will click the "new record"
button for a blank form.

Form 1
*Find Record
*If record is there, select and open subform for data entry
*If record does not exist, click on "new record" and open blank subform for
data entry

Any ideas. Several people will be working with this also so I need to make
it pretty simple to use.

John
 
If you just need one field to find the right record (e.g. a company name),
you can use a combo box. Details here:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html
(There is a combo wizard that does this, but it is not the best code.)

If you want to be able to select the field to use for finding the record,
see:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html
This one is very easy to set up. (Copy'n'paste - no changes needed to the
code.)

If you want to create a search form where the user can enter any combination
of criteria on different fields, see:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
This one takes a bit more work to code, but is very simple and powerful for
the end user.
 
Back
Top