Using a form to update a table

[El Rebelde]

My database is designed to record Comments made by auditors and Responses to them made by the managers of the units that have been inspected.

My process is:

Create an Inspection record
Record the inspectors' Comments
Print a Report of the inspection
Await responses by email, text or voice call
Select the relevant Inspection from a list shown on a form
Select the relevant Comment from a list shown on a form
Record the Response

I have a form to record Responses and, depending on the content of each Response I would like to update the Status field in the corresponding Comment record. Ideally I would like to choose the Status from a list box on the form.

What is the best way to do so?

 

[DCrake]

You seem to have missed out one crutial piece of information... What point are you up to now?

Where do we start in our answering process?

David

 

[El Rebelde]

You seem to have missed out one crutial piece of information... What point are you up to now?

Where do we start in our answering process?

David

Well, I have the database, the forms to enter the data and the reports to publish it. What I need to know is; having received a response, selected the specific Comment to which it relates and stored the data in a new Response record (created with a form), how to update the Comment record with a new Status.

I think that I ought to be able to choose the Status from a list box on the form, store that value somewhere, go to the Comment record and update the Status field with the chosen value. Trouble is I've spent all my spare time learning Spanish, riding fast bikes and acting (sometimes all at once!) so I've never learned how to write VBA.

Hoping for a clue!

Estuardo, el Rebelde

 

[El Rebelde]

Well, I've managed to achieve my aims by calling a new form from a button on the Response entry form. This Update form opens with the current CommentURN from the Response form entered as a default value and has an unbound list box from which I choose the Status. The on-click property of the Update Status command button calls a macro which uses these values to run an update query on the Comment table and closes the Update form.

Probably not very elegant, but it has two advantages; it works and I understand how it works!

Estuardo, el Rebelde

1959 - 2009
50 Años desde el triunfo de la Revolución:
¡Hasta la Victoria Siempre!