HDfatboy03
Board Regular
- Joined
- May 23, 2010
- Messages
- 62
Trying to create a form where the Combo Box "cboCourse" is loaded from a sheet "CourseInfo". There are 2 ranges "CLkup" containing 2 columns txtCourse and txtTbox and "Database" containing all the columns in the "CourseInfo". Currently my combo box is working thru the properties option Rowsource "CourseInfo!CLkUp" and is working. It's the next part where my opportunity lies ... lol
What I am trying to accomplish is when a selection is made in the combo box example: "Lindale GC (Black)" ... I want the rest of the text fields in the form "txtPar", "txtRating" & "txtSlope" to populate automatically from the excel worksheet "CourseInfo".
Please point me in the right direction, an example, something to read. I am 3 weeks new to all of this ... what started out as a simple spread sheet now seems to have a life of its own. Starting to get a lil addicted ... lol Any help will be greatly appreciated.
thanks HDfatboy03
What I am trying to accomplish is when a selection is made in the combo box example: "Lindale GC (Black)" ... I want the rest of the text fields in the form "txtPar", "txtRating" & "txtSlope" to populate automatically from the excel worksheet "CourseInfo".
Please point me in the right direction, an example, something to read. I am 3 weeks new to all of this ... what started out as a simple spread sheet now seems to have a life of its own. Starting to get a lil addicted ... lol Any help will be greatly appreciated.
thanks HDfatboy03