Pre-populating a value in a Form

[jamesk1979]

Any help will be much appreciated (as usual).

I have a table for training courses, with three fields;
1. ID
2. Course Name (eg. Word, Access, Excel etc.)
3. Course Type (Internal, External)

What I want to do is create a form (with a subform if neccessary) that pre-populates the read-only 'Course Type' value on the form, depending on which 'Course Name' value is picked from the combo box. For example, if I pick Excel, Internal will display, if I pick Word, External will display.

Is this possible? I'm no use with VB so steps on how to do it would be just fine.

 

[KenReay]

Hi

In the combo box, have two columns Course and Coursetype, you can set column width of coursetype to zero so user does not see it, in the after update event of the combo put Me.CourseType = MyCombo.Column(1)



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK