Save data as it is enerted.

[injanib via AccessMonster.com]

How can I get my form to store data that I enter in a field, so that next
time as I start to type the same data it populate the rest of the data. For
example, if I enter a company name "My Company" the first time, the next time
as I start typing "My..." it should populate all company names that begins
with those letters and have been entered before. Possible??

 

[Jeff Boyce]

Forms don't store data, tables do.

If you want a way, on a form, to see a list of the company names that match
what you are typing in, take a look at how the combo box control works...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[missinglinq via AccessMonster.com]

Or, of course, you could go back to Excel, which has this feature!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[Larry Linson]

Or, of course, you could go back to Excel, which has this feature!

An interesting comment... not something I have used, so I went into Excel to
try it out. And, if I enter "MyCompany" in A:1, then move to another cell,
and start typing, there's no offer to autocomplete as "MyCompany". Also, if
I enter, "MyCowboys" it does not, as I read the OPs request, go back and
change A:1 to "MyCowboys"... I also didn't see an AutoComplete option or an
Option in Tools | Options that appeared to enable/disable. What am I
missing?

Larry