Amend one form data from another form

[swaroop1012]

Hi all,

I am trying to amend the data entered into a table from one form with help of another form.

The database is like this:

I designed a form to enter the data of different wards and stores them in a table. The main important thing here is the refno field which depends on the wardname.

The information entered before is bound to change and so i need to create an another form to amend the changed data. care must be taken that the refno field should not get altered.

So I decided to create a form to search the data depending on the wardcode and display as a query or report. (Refno = wardcode-number ex: BH-1,BH-2, WE-1,SO-1,BH-3 etc). I am successful till now.

Now i need to know is there any chance of clicking on the refno field in the query or report so that it will open the form with the previous data in it, allow to change the details and update the data.

Thanks in advance.