ComboBox Code

[zgtrman]

The answer to this is probably simple but I have been out of the loop for a couple years and forgot how to do this.

I have a form with a combobox (unbound) that has the names of the tables that I have created.
The tables only have two fields in them
1. Key (Autonumber) (primary key)
2. Description (a memo field)

I need some help with a Command button click event that will look at the combo box for the table name and then put the contents of a text box (unbound) into the correct table and in the Description field.

I am doing this for work for myself and no one else will use it so error trapping is not necc.
I work in Tech Support and I have to document calls and alot of them are about the same thing...using notepad would be too long of a file to search thru. I support 10 diffrent softwares and I have tables for each of them.

Thank You in advance for any help or suggestions

To effectively improve in the efficiency of your performance, one must be proficient in the implementation of a positive mental attitude.

 

[mikej336]

If I understand you correctly....I am wondering why you need 10 tables when you could have 1 table and add a description field to the table and make it a drop down on your form.

Uncle Mike

 

[CaptainD]

I am doing this for work for myself and no one else will use it so error trapping is not necc.

Other then it's easy to add and it helps in debuging.

 

[zgtrman]

mikej 336

Ok I will attack the problem from that angle. Thx.

To effectively improve in the efficiency of your performance, one must be proficient in the implementation of a positive mental attitude.