Thanks very much for the replies. Something inside me dislikes using modules for single forms so I found another way via ADO rst's on the parent form. It's a lot more complicated than using an array would have been, but it works, and has allowed a little more flexibility.
Thanks very much for the info both of you :)
John Crozier
Last Activity: Dec 23 '10, 01:18 AM
Joined: Jul 8 '10
Location:
-
Refering to an array in a parent form?
Hello! I would like to retreive data from an array in a parent form. I think it's best explained by showing an example...
Parent Form
Child FormCode:Option Compare Database Dim ChildNum(1 To 255) As Integer ... 'Inside a sub I have a loop with this inside it... ChildNum(ii) = Nz(rstPODetails!RecordId)
Can anyone see where...Code:MsgBox Me.Parent.ChildNum(Me.CurrentRecord)
-
Thats bang on, thanks very much Nico! Don't know how I got stuck on that, but everythings simple in retrospect right? I'm grateful for the quick concise answer!
JohnLeave a comment:
-
John Crozier started a topic SQL Statement - Selecting between dates using dateadd() and dateserial()in AccessSQL Statement - Selecting between dates using dateadd() and dateserial()
Hello everyone,
I was recently tasked to convert some of the functions employees use Excel for into Access. One of these functions is seeing which invoices are due to be paid this month. Surely this is simple I thought, and so it would be - if I had a field with a duedate in it. However I am using the sum of two fields as my date and thus, I feel, I have a problem. It's the end of the day and I'm knackered, can anyone spot my Query...
No activity results to display
Leave a comment: