Unanswered: Display query field on a form based on a table
I'm trying to create a form to input risk data (consequence and likelihood) for a project to a project risk table. Each project can have a number of different risk scenarios so the form is in tabular format. I have also created a query to "calculate" (actually a lookup) the risk score base on the consequence and likelihood.
I would like to display the risk score on the data input form as I complete entry of consequence and likelihood for each scenario.
How can this be done?
I can create the for for inputting the risk data easy enough, the dificulty arises once I attempt to display the risk score.