Updating Tables & Combo Boxes

[mjc2002]

I have a table called "writers" with a list of writers (fieldname = "writer&quot. I have a main form called "books" which, as well as stuff like title, year, ISBN, rating, comment, etc. also has a combo box (named "author&quot which calls up my writers table.

When using my authors combo box, I can either select an existing author or add a new one (having set my combo box to allow addition to the list). This works fine, but if I add a NEW author directly on the main form (ie. via the combo box), my writers table is NOT updated for later use. Of course, I can get round this by only adding authors via my main writers table, but this is not very practical.

Could you tell me how to update my main table, please? Preferably with actual code (my form is called "books", the table is called "writers" and the combo box is called "author&quot- or as closely as possible. I've just trawled through the forums here looking at replies to similar queries but I don't understand any of them (!), I'm afraid, so please do keep your reply simple.

Cheers

Mike

 

[pgk]

Hi,
In the code part where the new record is added, add some to enter the new author in the writers table also. Hope it helps. Let me know what happens.
With regards,
PGK

 

[mjc2002]

Thanks PGK but WHAT code?! I'm a complete novice, remember!
Cheers
Mike

 

[pgk]

Hi,
How is it that you add a new record to your table using the main form? When you enter a new author using the combo box, you say are able to add that to the table. How do do that? Hope it helps. Let me know what happens.
With regards,
PGK