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