Simple Form - Problems

[Nibbles]

Hi all, looking for a bit of help.



I currently have a datatable (in excel) that I am moving to Access, and want to make use of the Forms feature. This data table has the following columns; Company Name; Contact Date; Info; Contact Again?.

Essentially, the idea is that whenever I contact a company I can click on the form, select the company from the drop down list of companies (assuming I have already contacted them, if not I would add a new company name), set whatever date i contacted them and some information about what was discussed in the call. The idea then being that whenever I contact someone I can query that company which will give me a list of all the contact dates and what was spoken about during each one.

Creating the datatable is simple enough, but I cant get the company name list to populate with the names of companies already in the list. I assumed I could use listbox or combobox to do this. Ive set bound column to 2 (column 1 is 'ID'?!). This basically means that every time i want to add a 'call' i need to type in the company name manually, which opens it up to typos etc. I was hoping that this column could be an autocomplete where i may type the first 3 letters and it would suggest what i wanted to input.

Any thoughts?

Im an access newbie, it has to be said, though im familiar with excel/word etc. Would this be easier in Excel?

[alansidman]

Try this

http://www.datapigtechnologies.com/f...tomfilter.html

[Nibbles]

Hi Alan. That helped a little, thanks.

However, the list I now have of companies has multiple entries for some of the companies. What it seems to have done is list every entrie in the companyname column rather than every unique entry. Is there a way to make it do this?

[alansidman]

In your sql statement for the combo box, Click on the Sigma symbol. It will then group on and make unique the entries.

Look at this: http://www.datapigtechnologies.com/f...combobox1.html

[Nibbles]

Ah perfect, thats done it. Thanks