I currently have a single form that when i fill in a date and press a button the receive field will populate the received field from the box where i enter the date. I want to move the data to a subform while the main form still has the controls. This is the code that works when it is a single continuous form. attached is a screen shot of the form and subform that i would like to use

Private Sub Command22_Click()
Dim rs As DAO.Recordset
Set rs = Me.RecordsetClone
Do Until rs.EOF
rs.Edit
rs!Received = Me.Text20
rs.Update
rs.MoveNext
Loop


End Sub

Thanks

Hi,

To convert your code from updating the main form to work for a subform, try modifying this line from:

Set rs = Me.RecordsetClone

to:

Set rs = Me.SubformContainerName.Form.RecordsetClone

Hope that helps...

Thank you..... I don't see how i missed that one....been working too many hours on this one (IMG:style_emoticons/default/smile.gif)

Thanks Again

Hello, Question...
It works the first time but i must close the form and go back in to it to do it again. any thoughts

This post has been edited by Araman: Jan 16 2011, 08:46 PM

Try adding these after the Loop:

rs.Close
Set rs = Nothing

Hope that helps...

Hello,

I get an error when i go to reset the date field for a new batch. Included is a screenshot of it.

Thanks

Hi,

Can you post your updated code? Also, have you tried using Recordset instead of RecordsetClone?

Hello. I tried using recordset and the subform has the #name error in the fields

this is the code

Private Sub Command22_Click()
Dim rs As DAO.Recordset
Set rs = Me.frmNotReceivedSub.Form.RecordsetClone
Do Until rs.EOF
rs.Edit
rs!Received = Me.Text20
rs.Update
rs.MoveNext
Loop

rs.Close
Set rs = Nothing



End Sub

Hi,


Did you mean you already tried it this way?

Set rs = Me.frmNotReceivedSub.Form.Recordset



If you did try it as a Recordset and not RecordsetClone, you might consider posting a zipped up version of your db because I can't really tell what's wrong with your code.

Just my 2 cents...

The Code works as it suppose to. I'm wondering if the the form itself needs to be reset, refreshed or something like that after the code runs

Hi,

I don't see any harm in trying. Let us know how it goes...

Ok here it is. the form in question is under the edit tab amd is receive orders

Thanks

This post has been edited by Araman: Jan 22 2011, 08:38 AM

Hi,

I got a "Unrecognized database format" error when I tried to open your file. Are you using Acc2010?

yes, with the new navigation system

i can up the original done 2 years ago in access 2007. It's 2 files as it is split when in use. it has the same issue as far as only 1 mass update then i must close the form . although i do not get the error i showd earlier.

This post has been edited by Araman: Jan 22 2011, 11:47 AM

No, that's okay. I'll just have to wait 'till I can download your db on a 2010 machine (unless somebody else beats me to it).

Later...

thanks

Hi,

Just want to give you an update, sorry for the delay but I probably won't be able to get to an Acc2010 machine until this weekend. I hope I am not causing you any problems with this delay.

No, Not at all. It was a bug with the last version also, just never realized it so it's no big deal. i've made a lot of change since the upload as so far as table normilization but that should have no effect on the issue at hand or its resolution.

Thanks

This post has been edited by Araman: Jan 27 2011, 11:54 AM

Hi,

I was finally able to download your db. If you see this post today, could you please give me a step-by-step on how to duplicate your issue? Thanks.