Data entry

[tarhim47]

Hi,

I have a form which will be used to gather data from the users. One of the fields is "leads." This is supposed to be potential clients the partners/managers are trying to attract to our firm. So there is no way for me to create a table of leads. Aother field is "COI." These are people who introduced the partner/manager to the lead. Majority of the COIs are new and some will be old who constantly refer others to our practice. In either case, there are not enough old COIs for me to create a table of them.

What I want to be able to do is have the form remember COIs entered on past records. For example, if the COI on record 1 is Murphy then if the same COI referred us to lead 10 (recorded in record 10), I want the user to start typing in the COIs name and have access generate a list of COIs who have similar names and allow the user to select from that list.

I tried convering my COI field to a combox and turned on Auto Expand but it still doesnt remembe past entries or shows a list of them.

Any ideas? Your help is greatly appreciated!



Thanks.

P.S. my dbase is attached.

[June7]

Combobox RowSource must retrieve info from the table of past records. Something like: SELECT DISTINCT COI FROM table ORDER BY COI;

I assume you are saving a Name instead of ID for the COI because you don't have a lookup table for COI's.

[tarhim47]

Hey June,

Thanks so much for your help.

I tried what you said and it doesn't seem to work, probably b/c I didnt enter it in correctly b/c im new to access. And your assumption is correct. I am recording the name of COIs in the "Lead Activity Report" form. You can open up my dbase in the initial post for clarification.

Do I have to put COI in quotes ("") or brackets ([]) or anything like that? Basically what Im trying to accomplish is a list of past entries. Something like the search box in Windows XP. If you search for something once, Windows will remember it and if you try to search for the same item again it shows up as a list which you can then select, therefore not having to type the whole word/phrase again.

Thanks for ur help!