I think you are doing this the hard way.
As I understands it, you have a table "Allotment" where all information including the remarks are stored.
When you select the records to be updated they are already in the allotment table, but needs the remark you have just written in the txtRm field in the form. Right?
So you have several records with the same Financial Year, Demand No, Major Head, Minor Head and Sub-Head?
I hope somewhere there is a difference between the records otherwise they are just clones...
But I would go to the query builder (you find it on the ribbon between tables and forms).
Then select the Allotment table (right click in the grey area and select show tables) and select the fields you want to do the search on.
That might be: Financial Year, Demand No, Major Head, Minor Head, Sub-Head.
For each choice you have a coloumn but I will only do the first for you ;)
Field: Financial Year
Table: Allotment
Sort:
Show: (Yes)
Criteria:
Or:
In the criteria field you write: [Forms]![NameOfYourForm].[cmbFY]
This will give you exactly what you have written in the field cmdFY.
If you want "and something like it" you write: Like [Forms]![NameOfYourForm].[cmdFY] & "*"
You do the same for all the other fields you have selected.
This is your search query. You click Run on the ribbon to see if you get what you want.
When this is working to you satisfaction you can convert it to an update query (the 6'th option on the ribbon, at least for me).
You get a new row named "update to"
here you write: [Forms]![NameOfYourForm].[txtRm]
To get the button to run the query for you, you write:
- Private Sub cmdUpdate_Click()
-
'Updates Remark field in table Allotment
-
-
With DoCmd
-
.SetWarnings False
-
.OpenQuery "the name of your query"
-
.SetWarnings True
-
End With
-
-
End Sub
You might want a subform to display the records but that is up to you.
And you should be home free ;)
Unless I totally misunderstood you this is the way I would do it.
12
