Your welcome taraj, glad you got it going OK.

Bob

Hello taraj & Bob!
I've been searching for my question everwhere for a few days and I finally came to this forum. This one is exactly like my problem and would love to find out how you guys solved this issue.
I've tried your suggested code, but can't past the "Dim rst As DAO.Recordset" line.
I placed this code in command button's property, and clicked on build event. It opend VB window, I pasted the whole script and this was what I had after I update the changes.
==code==
Private Sub Command8_Click()

Dim rst As DAO.Recordset

   Set rst = Me![client-query].Form.RecordsetClone
   rst.MoveFirst

    With rst
      .Edit
      !Name = True
      .Update
    End With
End Sub
==code end==
by the way- my Main form is called "Main-enter" and sub form is called "client-query". Field I'm trying to update here is "Name". But is it possible to update multiple fields (this I will ask again, after I can get the first part working)?

What am I missing? and when you say "set reference to the Microsoft DAO 3.6 Object Library", how do you do that?

Can you guys please help!!!! I going crazy with this one...

Make sure your DAO library is turn on. In any VBA code window, click Tools > References and make sure the Microsoft DAO 3.6 (or later) Object Libary is checked. Also, do not name any field "Name". That is a reserved property in Access. It can cause problems with VBA and queries. Rename the field "Name" to something else that is not reserved, e.g. strName, strFullName, etc.



Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

SerranoG,
Thank you for that info! I didn't even check about the "name" field thing... So I guess I have to go back and change everything...
Also, when I go to my MS VB's window, "References" section is grayed out... What am I to do? I tried it with codes opened and without codes opened... Is there anything special I'm supposed to do?
THANKS FOR ALL YOUR HELP!

"References" is grayed out?! Are you working with the MDB or an MDE? If the MDB, I don't know what would cause that unless you don't have proper permissions to edit the database fully.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

I happened upon this thread, and it almost walks the question I need answered. Moderator, forgive me if this strays out of bounds.

I need to have a similar code that works like this:

When I click a command button, I need it to update a corresponding field in a table. IE: click command Button 1, field one in table "XXXX" registers a hit, or a number. One click, 1, two clicks, 2, etc., etc.

Is this doable?

Many thanks in advance!

I happened upon this thread, and it almost walks the question I need answered. Moderator, forgive me if this strays out of bounds.

I need to have a similar code that works like this:

When I click a command button, I need it to update a corresponding field in a table. IE: click command Button 1, field 1 in table "TableName" registers a "hit", or a number. One click, 1, two clicks, 2, etc., etc.

Is this doable?

Many thanks in advance!