Search results for query: *

Thanks!! I see what you're getting at. I never thought of doing it like that. I'll give it a shot!! Thanks so much for your help!! Ang

Yes I can supply that info. the subreport is based on a table, and the Table is based on a query. I end up doing all my grouping and sorting in the report. The default is Case 1 of my code. And the Case Select is based on two radio buttons: Case 1 - we want to sort on...

Thanks so much for all the replies. I am including the code I thought should work which was very similar to TheAceMan1's suggestion. The keys are this is a subreport and the third sort item changes. I put this in the "On Open" of the subreport and it errors out on the first sort line of the...

I have a subreport that is being used by two groups, therefore, it needs to be sorted two different ways. I tried using "orderby" and got errors. I also tried to use Me.GroupLevel(0).ControlSource = "Parent" coding. I also got errors with that. I can work these sorts fine in a report. It's...

Thanks so much!! I'll give that a try!!

In trying to simplify the probelm, I may have gone too far. Here are the steps I'm looking at. 1. A New Record Button is pressed and the user opens the Main Form on a new record with a new Log#. His/her userID is placed in the SubmittedBy control. 2. The user can input an Alternate Submitter...

The subform is based on a table that has Log# and UserID. The UserId was converted into a combobox based on a UserId/Name table. Thanks for looking at this!!

I want to open a Form using criteria from a subform. I have a form that has two fields: * Log# (AutoNumber) * SubmittedBy. SubmittedBy is automatically populated with the user ID associated with the person who originally created the record. The current user's ID is sUser. Right...