Question 2: I want my combo box to automatically update the underlying table

[not a code fan]

I know other people have already asked this question but all the anwers i have come across give lots of computer coding i don't understand.

I have a combo box with some entries already in it but when i make a new entry i want to automatically update the source table the existing entries come from so next time i open the combo box i can see the new entry i made last time, in the combo box list.

I need to understand how to write the code required to overcome the problem above. I have seen some full examples of the coding solutions used but i don't know what means what and would really appreciate some information as to how to understand coding so i can use what info i have found on the above problem.

 

[Mile-O]

Have you seen this?

 

[not a code fan]

coding confuses me

Hi SJ McAbney

I had already seen that link you pointed me to, but for someone who has never used that part of Access it's rather daunting. I don't understand what any of that means. If it were a case of just pasting it in fine, but i have no idea what should and shouldn't be pasted in and i imagine that i have to add text which is relevent to my database. I need to know what it means before i can use it and so far i haven't found an understandable explanation.

 

[Mile-O]

But it's commented throughout. The whole lot is used.

The only bits you change are:


Set rs = db.OpenRecordset("MyTable")

by changing MyTable to the name of the table you are adding to.


.Fields("MyField") = NewData

by changing MyField to the name of the field you are adding to.

 

[not a code fan]

success

Well i managed to make it work thanks to your advice. My problem was knowing what was what within the code. I didn't even know if i was supposed to delete the commentary throughout the coding or whether that would mess it up. With your little extra instruction i managed to get it to work, not without the odd glitch or two as i had the odd dot missing etc. I have Office 2003 so that through an extra spanner in the works. But i used the thread you added about checking this and unchecking that.

Many thanks again. Now i'm trying to get my head around one combo box filtering another combo box in the context of a persons address (City/Country)