Combo Box Populating Multiple Text Boxes

[zuchowra]

Hi everyone. I need help. I have a combo box in my form that i want to populate multiple text boxes after you select your selection in the combo box. Here is my set up.

The Fields that need to be populated are lsited below but must be recorded to a new table. Gets info from Course occurance Table.

Combo Box - Gets Information from Course Occurance Table. This table has all information regarding course information.

Course ID:
Course Name:
Hours:
End Date:

So after the selection is made from combo box. It populates these fields. Combo box gets info from course occurance table. The fields on the form are linked to the grades table on my data base. I want the info pulled from course occurance table then populate it in these fields . Which will then be recorded to the Grades Table. I have the combo box working just i cant figure out how to populate the fields. Please Help.

Sincerely,
Ray Z

[zuchowra]

Im using Access 2007. Please Help!

[puppydogbuddy]

Im using Access 2007. Please Help!

If I understood correctly, you would use the AfterUpdate event of your combo to update the textboxes as shown below. Replace the generic names I used for your textboxes and your combo box with the actual names used in your application.

Private Sub YourCombo_AfterUpdate
 
If Not IsNull(Me!YourCombo) Then
     Me!txtCourseID.Value  = Me!YourCombo.Column(0)
     Me!txtCourseName.Value = Me!YourCombo.Column(1)
     Me!txtCourseHours.Value = Me!YourCombo.Column(2)
     Me!txtEndDate.Value = Me!YourCombo.Column(3)
     Me.Requery
End If
End Sub
 

[zuchowra]

Thanks. You are the Best. I appreciate it.

[deedeem]

Thanks. You are the Best. I appreciate it.

By the way, I am having the same problem. My combo box has two fields from an underlying query called MMS and Rev. I want to requery the form based on these two values and only know how to do this for one value. My combo box has a name of Combo14 and I don't know how to refer to the values separately if you know what I mean. My code looks like this and worked when I just queried based on the MMS. When I decided I needed to query based on both MMS and Rev I got lost.

Private Sub Combo14_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[MMSCode] = '" & Me![Combo14] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

Help. By the way, how do I get the answer to this question. I tried posting a question before and still have not figured out how to go see if someone answered it.

Thanks so much,
DeeDee

[puppydogbuddy]

By the way, I am having the same problem. My combo box has two fields from an underlying query called MMS and Rev. I want to requery the form based on these two values and only know how to do this for one value. My combo box has a name of Combo14 and I don't know how to refer to the values separately if you know what I mean. My code looks like this and worked when I just queried based on the MMS. When I decided I needed to query based on both MMS and Rev I got lost.

Private Sub Combo14_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[MMSCode] = '" & Me![Combo14] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

Help. By the way, how do I get the answer to this question. I tried posting a question before and still have not figured out how to go see if someone answered it.

Thanks so much,
DeeDee

DeeDee,
If you click the hyperlink to your profile in upper left, you will see links to all your previous posts and threads. In regard to the problem with your combo, I need a little more info..............see below:
1. what are MMS and Rev ? what is the primary key to your table(s) that have MMS and Rev in them.
2. show me a one line sample of what the data looks like.

[deedeem]

Thanks so much for your time. I just figured out how to get to the answers to my posts!!! Ha Ha.
I did get the answer to this problem. You use the .column() subscript to refer to each element in the combo box.

Now I can look for answers to my posts. I appreciate your help.
I'm new so forgive me.
DeeDee

DeeDee,
If you click the hyperlink to your profile in upper left, you will see links to all your previous posts and threads. In regard to the problem with your combo, I need a little more info..............see below:
1. what are MMS and Rev ? what is the primary key to your table(s) that have MMS and Rev in them.
2. show me a one line sample of what the data looks like.