Can a combo box accept input?

[Bee]

Hi

I have searched for this in the forum search, but nothing related came up.
I am wanting to make a combo that will allow data entry as well as display the normal drop down list for viewing data. Is that possible in the combo control in Access?

Any suggestions will be very much appreciated.

Thanks,
B

 

[wazz]

http://www.access-programmers.co.uk/forums/showthread.php?t=123923

 

[Bee]

http://www.access-programmers.co.uk/forums/showthread.php?t=123923

That's great - Thanks.

 

[Splinters]

http://www.access-programmers.co.uk/forums/showthread.php?t=123923

Does this work with Access 2000 as well? I copied it to my DB, but get an "undefined function" error message.

 

[wazz]

not completely sure of the error msg but it could be a missing reference.
in vba editor go to tools-references and make sure 'microsoft dao 3.6 object library' is checked.

also make sure you've changed all the "terms" in the code to match what you have, ie. change cbo"Name", tbl"Name", "Company", etc. to match the names of your own combobox, tablename, and field you want to update.

 

[Splinters]

not completely sure of the error msg but it could be a missing reference.
in vba editor go to tools-references and make sure 'microsoft dao 3.6 object library' is checked.

also make sure you've changed all the "terms" in the code to match what you have, ie. change cbo"Name", tbl"Name", "Company", etc. to match the names of your own combobox, tablename, and field you want to update.

That did it - thanks!

I also found that I needed to keep the items you mention in the quotes to avoid an "unknown variable" error...

Thanks,
Stephen