please help me to design this form..

[saleemMSMS]

well, this is what i want to do.. i have 2 tables
Books (bookID, title, authorID, price)
Authors (AuthorID, AuthorName)
when i generate 2 forms using the form wizard, 2 forms will be generated.. but in the books form, there will be a text box to enter the authorID. what i need is to have a reference to that point so that the data entry operator will not get confused.
so i thought of placing a combo box in front of the authorID text box in the Books Form. this combo box will have all the author names in it. whenever the used selects an author name, the Author ID text box should get filled with the respective author ID of the selected author name.
so i built a query saying select AuthorID form Authors where AuthorName=<a parameter>
but i'm unable to link this query with the combo box's onChange event. this is what made me to ask this question.

so PLEASE can u guys tell me is my approach wrong ? if it is not wrong, what am i missing here??
if its wrong, PLEASE explain me the correct way...

THANK YOU VERY MUCH FOR DEVOTING TIME ON THIS QUESTION
sorry again for being rude in previous occasions

[dcrake]

In your combo box have two columns Author Name and Author id set the author id as the bound field but only show the author name. Then on the after update event of the combo set the textbox that displays the author id to

Me.TxtAuthID = Me.CboAuthors

David