How do i Set the Selected Field value In a 2nd combo box with a field in 1st combo box once a field is selected in the first combo box?

[Tom d]

How do i Set the Selected Field value In a 2nd combo box with a field in 1st combo box once a field is selected in the first combo box? The 1st combo box is loaded with the contents of the Booklibrary TBL, which contains the AuthorsID. The second combo box is loaded with the contents Of the Authors TBL. See the Update/Delete a Bookbutton on the Main Menu Form.

 

[CJ_London]

Sounds like you are using cascading combos - take a look at this link

enabling cascading comboboxes in datasheet or continuous form

Having been asked about this recently, I reinvented some code I developed to work with datasheets and which also works with continuous and single forms. The attachment was developed in 2010 but saved as 2003. The db demonstrated two techniques for using cascading comboboxes. Technique 1 is...

www.access-programmers.co.uk

 

[Pat Hartman]

Just FYI. Choosing an item from the first combo does NOT automagically pick an item from the second combo. The first combo is used to filter the RowSource of the second combo but the user must always choose the value he wants.

Sure wish you had paid attention to the sample I pointed you to days ago

What do you expect Book Update/Delete form to do? Please, Please, Please at least look at the working sample I posted earlier to see how you can open a maintenance form from a combo (or in the case of the sample, a listbox - but the concept is identical)