Need Help With Combo Box

[Phased]

Hello, I am currently building a Database about a Driving School so to speak, I have a Table named tblTest and I have a Combo Box for an entity labelled "TestType" which has 2 selections: "Practical" & "Theory" the last entity is labelled "TestCost" is it possible for the TestCost to change depending on what the user selects in the TestType Combo Box? If so how is this done?



I have looked all over the internet for help, and alas have had no such luck so far, thanks in advance for any contributions

[orange]

Something like this might help with the concept. This just uses the value selected in the combo, and outputs a phrase in a textbox called Txtbox on the Form. Any calculation could be done.

Private Sub cmbTestType_AfterUpdate()
'Test to have different calculation based on Combo Selection
If Me.cmbTestType.Value = "Practical" Then
Me.TxtBox = "Test Cost is $50.00" 'Practical test
Else
Me.TxtBox = "Test Cost is $20.00" 'Theory test
End If
End Sub

Hopefully you are not storing the calculated result in your table.

[Phased]

Thank you for your reply I am not storing the calculated result no. Also where would I place that code? I am quite the Access novice

[orange]

This is in the AfterUpdate Event of the Combobox.

Check with Access help or do some google search

Here's one http://msdn.microsoft.com/en-us/libr...ice.12%29.aspx

good luck

[Phased]

Thank you very much!