Is it possible to use autocomplete for data entry in access forms

A

AJMPRO

I am in the process of entering data in a form that has a lot of repetious
data entry phrases. I want to know if I can set up autocomplete in my form
for data entry? Or is there any other way to address this to expedite data
entry?
Thank You
AJM
 
R

Ron2006

Autocomplete works off of combo boxes. (And list boxes, I believe, but
I prefer combo boxes myself.)

All sorts of things can be worked off of that including pre-filling
other columns based on selection etc.

At a very minimum a combobox for each field you want to auto complete
on.

You can use the table you are adding to as the source for the
information with "Select Distinct" or Sum queries with group by to
get unique entries for each. And cascading comboboxes to help limit
the selections of successive fields based on a selected value in an
earlier field. (do a google search on cascading combos in these groups
to get lots of ideas and examples.)

Hope this gives you some ideas to research
Ron
 
J

John W. Vinson

I am in the process of entering data in a form that has a lot of repetious
data entry phrases. I want to know if I can set up autocomplete in my form
for data entry? Or is there any other way to address this to expedite data
entry?
Thank You
AJM

More details please. Are you building up long paragraphs from boilerplate
text? storing multiple repititious fields? Entering data using textboxes, or
combo boxes, or what?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top