1 forum two tables linked fields - need help

[Novice_VB-Programmer]

OK, I am familiar with SQL, and I am familiar with Access (as much as I can do in the GUI for basic to intermediate design)

I have never programmed in VB Script - and I'm afraid it's the only way I can do what I want to do.

What I'm working with: I have a list of tests (various subject that students MAY take) and the current passing score according to the state. The state may change the passing score over time. This is in the table PT_Lookup with the fields of TT_Num (autonumber) TT_Name (text) PassScore (int)

I have the need to record the student grade on any given test and the passing score of that test at that time, and a boolean value (pass=1/fail=0) in another table (PT_Result).

My form that I'm using pulls the name and TT_NUM and pass score in the combo box. The form can write the test ID (bound column) and the user enters actual score to the PT result table, but I can't find a way through the wizards or field properties to write the other 2 values I need -namely the 3rd column - not bound and the pass fail field based upon a comparison of the earned score and the pass score.

I would like these to 'self update' on the form as the user is filling in data for that record if possible - perhaps using an event after each field is updated - so the user can have a visual confirmation of the data as it will be written.

 

[scalextric59]

<your field> = me.<your dropdown>.column(2) would be the value on the third column of the dropdown

 

[Novice_VB-Programmer]

Thank you for the vb script, ow - bigger question, where do I use it? macro? module? I need some hand-holding for this. - Sorry.

 

[scalextric59]

I am not sure how your program works, but I guess you would need to include the code in the <your dropdown>_AfterUpdate event, so when the user updates the value in the dropdown, the other values (non-bound columns) will get updated at the same time.
By the way, this is not VB script, it is VBA (Visual Basic for Applications)