Order by with sub forms

G

Guest

I've got nested subforms; a Main form with a subform that contains a subform.
The main form has Employee data, the first subform contains project(s)
information and each project has comment(s) in a subform.
I'm trying to figure out how I get the Projects to show the most recent
projects.
I'd like to also have the comments show the most recent (max date?) comment.
I assume I would use the "Order by" data property... but it's not working
for me.
I assume I would use the following fields:
Projects - ProjectNumber (combination date & sequential number).
Comments - CommentDate.
I think this should be easier than I'm experiencing.
Any advice would be appreciated.
Bill
 
G

Guest

My brain is functioning again...
I found the Me.OrderByOn and updated as necessary. I've got it Working the
way I wanted it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy data from 1 subform to another subform 2
Multiple sub forms 1
Problem with TreeView on a shared subform 1
Go to record on subform using combo box on main form 1
Hiding (sub) forms 2
m:n forms 1
Storing a date in the main form from the subform 2
Creating a Sub-Form to record Sub-Projects 3

Top