I have a form "ScoreSubmision2" that has data on it that applies to all the records in my report. the recordsource of the report is a table. On the report I have a couple unbound textboxes because that data is not in the table. I want to pull that data from the form. I have set the control...
I don't see DAO avaliable in my list. I am using Access 2003. here is the code I am using
Dim rst As ADODB.Recordset
Set rst = Forms!form2.RecordsetClone
Dim str As String
Do While Not rst.EOF
str = rst.Fields("{ID}").Value
str = str & " " &...
I select several items from a list box and then I take those items and create the recordsource for the form. on my continuous form I will have a textbox to add some data for each record, then I need to dump the info for each record into a table. I have found info on RecordsetClone which looks...
I am creating a continuous form with only 3 fields that will end up having about 30 rows. I want to then be able to take the data on the form and add it to a table. Can someone give me the code to do this since you realy only have 3 field names
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.