Requery Textbox after making selection from combo box

[Access_Novice]

I have a combo box called "className" and a textbox called "tuition." After I make a selection from the combo box, I want the textbox to requery the record source (which is a query) so that the value of tuition will be the proper value depending on what is selected from the combo box.



I am not getting an error. The textbox just doesn't update at all. Here is my code:

Private Sub className_AfterUpdate()
    Me.tuition.Requery
End Sub

What am I doing wrong?

[ItsMe]

Just a little side note. The combobox's Control Source property can be assisgned to a field within the recordset. This will cause the assigned field to be updated with the value of the bound column of the combobox. Now back to your question.

Save your record and then requery your textbox.

Private Sub className_AfterUpdate()

if me.dirty = true then
me.dirty = false
end if

Me.tuition.Requery
End Sub

[ssanfu]

Oops, I should have read Help closer... so I edited this..

This is how I would update the text box

If the tuition value is in the row source of the combo box, you can use the after update event of the combo box to update the text box.

If the tuition value is in the 3rd column of the combo box row source, then you could use

Private Sub className_AfterUpdate()
    Me.tuition = Me.className_AfterUpdate.Column(2)
End Sub

(Combo box is zero based so 0 it the first column... 2 is the 3rd column)

[Access_Novice]

Oops, I should have read Help closer... so I edited this..

This is how I would update the text box

If the tuition value is in the row source of the combo box, you can use the after update event of the combo box to update the text box.

If the tuition value is in the 3rd column of the combo box row source, then you could use

Private Sub className_AfterUpdate()
    Me.tuition = Me.className_AfterUpdate.Column(2)
End Sub

(Combo box is zero based so 0 it the first column... 2 is the 3rd column)

I'm confused. I have the database attached. I am on the form called 'frmMembership' which is based on the query called 'qryMembership.' The Row source for the combo box is a simple query of the table called 'Class.'

[ItsMe]

What purpose does 'frmMembership' serve? Couldn't a member enroll in more than one class?

[Access_Novice]

What purpose does 'frmMembership' serve? Couldn't a member enroll in more than one class?

No. Each gymnast would be enrolled in only one class at a time.