The structure of CSR_Content is almost the same as the structure of CourseContent. The main difference is that I have left out the text field Content from CSR_COntent - but given the approach above, i guess this should be included now? Unless of course the query used to populatte teh subform reads data in from both CSR_Content and CourseContent I guess...
To be specific though, CSR_Content has the following fields:
CSR_ID (Number)...
ChrisD76
Last Activity: Jun 2 '10, 02:14 PM
Joined: Jan 7 '10
Location:
-
The Name of the Main Form? NewCSRForm
The Name of the Sub-Form? CSRContent
The Record Source of the Sub-Form? Table CSR_Content
You would not be populating the Sub-Form itself, but the Record Source of the Sub-Form, then Requery it. Interesting - so I have a table which includes course content, which is where my recordset reads it's data from. So then my recordset needs to be written to the underlying table CSR_Content, and then...Leave a comment:
-
Apologies for the delay - a couple of manic weeks at work... The subform was simply created separately and dragged on to the main form...Leave a comment:
-
Thanks guys for your help. I was actually hoping to write the recordset to a form, something like the attached. I cannot figure out how to get the recordset to populate the subform. Once this data is in the subform, the idea is that the user can simply tick the box next to the units they want to include and then save this data into a separate table, and at the same time generate a report to be printed. And as I mentioned previously, I need to be...Leave a comment:
-
Expanding code to include dynamic array
Thanks again for your assistance on this. I have now extended the code to attempt the next step, which is to write the content of the recordset into an array, and have run into a problem. I have now got two questions - should I be using an array at all? If so, what have I done wrong?
My intention here is to have a form with a multiselection combo box. Based on the CourseCode (or...Leave a comment:
-
Absolutely marvellous - thanks!!!Leave a comment:
-
How to pass a variable to FindFirst in DAO Recordset?
Hi,
I am new to using VBA, and have been working with DAO Recordsets. I'm working on a little problem, and think that DAO Recordsets are the solution. I've been playing around with them to try and get it working, and have the following code, which works perfectly:
...Code:Function ReadCourseContent() Dim db As DAO.Database Dim rst As DAO.Recordset Set db = CurrentDb() Set
No activity results to display
Leave a comment: