SubReport on Form (1 Viewer)

[JamesJoey]

About a week ago we worked on a subreport on a form that persistently showed the
unused part of the report.
Most of it has been cleared but it still shows the unused part under certain conditions.
The subreport has fields for reminders: ReminderDate, ReminderTime and Reminder.
I click on the Reminder and I open an editing form from which I can edit the Reminder
or delete the reminder. This occurs when I select the last reminder and change the date to an earlier
date and close the editing form. The space where the data was, show up white unless I close and
reopen the form.
When I add a new reminder and the date is later than the other reminder it doesn't
get requeryed, showing only the the date. Unless I close and reopen the form.
I've spent the last week trying to remedy this with no luck.

If there seems to be no solution then how might I accomplish the same thing with
a continuous form.
If anyone's interested I attached the pertinent objects.

 

[Uncle Gizmo]

Why not use a form?

 

[June7]

I suspect reason is because of the grouping that is available with report.

Only thing I can suggest to emulate the report grouping would be a treeview control.

 

[JamesJoey]

I thought about a tree view. I'll look into it.

 

[Pat Hartman]

I don't see the problem. Can you take a copy of the form and mark the problem for us?

 

[JamesJoey]

I thought about a tree view. I'll look into it.

I looked into a treeview and it's way out of my league.

 

[JamesJoey]

I don't see the problem. Can you take a copy of the form and mark the problem for us?

 

[isladogs]

I've created a continuous subform to mimic your report
I've quickly tested adding new records & deleting the last record.
It seems to work OK in my quick tests. See what you think....

I've also added code to allow easy editing of a record by double clicking on the reminder

 

[JamesJoey]

Great!
Exactly what I was looking for!
I want to thank you for your time and effort. It is appreciated.

I'm 66. 20 years ago I would have worked on this myself but I'm too lazy now.

Again thanks much,
James

 

[Pat Hartman]

Thanks for the picture. I didn't see the problem because it didn't occur on my PC..

Colin made a great solution

 

[isladogs]

@JamesJoey
You're a youngster compared to me!
In fact, it only took me about 15 minutes to do

In general, you should avoid using reports as subforms as you lose functionality.
Similarly avoid using forms as subreports... unless you really have no alternative.

 

[JamesJoey]

Is there a way to group by date?
That was my aim.
I can deal with the way it is.

 

[isladogs]

Ha! I wondered when you would notice that.

Unfortunately its not so easy to do on a form as on a report as it doesn't have a sorting & grouping feature
Also forms don't have a Hide Duplicates property

I did think about putting the date line ONLY in the subform with the event in a sub-subform
BUT that's not possible as its a continuous form

I'll think about it a bit more & let you know if I come up with a simple solution

 

[JamesJoey]

I didn't see it right away.
I'm currently using a crude week view with 7 subforms and the dates across the top.

Thanks again.

 

[isladogs]

Something like this but for one week only?

What I liked about your original design was its clean & elegant simplicity.
Trying to provide grouping on a subform will likely necessitate losing that elegance.

 

[JamesJoey]

I did like the clean look. I was unable to resize it properly in Paint.
I don't go from Sun to Sat. Tomorrow the first day will be Monday.

 

[isladogs]

It still looks Good. If you wanted, you could remove the white borders for a slightly cleaner look
Anyway, hope your shingles jab goes well. Having had shingles last year, I'll have that jab as soon as its available to me. Only for those over 70 in the UK

 

[JamesJoey]

I've been putting the shingles vac off.
I can use a darker color for the borders.

 

[isladogs]

I went back to this and have worked out a way of grouping the subform by date using a subquery:

I believe this provides the layout you wanted whilst retaining the original clean, simple layout

The subquery is used to give a rank order by day:

SELECT tblReminders.ReminderDate, tblReminders.ReminderID, tblReminders.ReminderTypeID, tblReminders.ReminderTime, tblReminders.Reminder,
(SELECT Count(ReminderID) +1 As HowMany FROM tblReminders AS Dupe
WHERE Dupe.ReminderID> tblReminders.ReminderID AND Dupe.ReminderDate= tblReminders.ReminderDate) AS RankByDay
FROM tblReminders
WHERE (((tblReminders.ReminderDate) Between Date() And Date()+7))
ORDER BY tblReminders.ReminderDate, tblReminders.ReminderID DESC;

NOTE: I also changed your date filter to Between Date() And Date()+7
Results as used above are:

Let me know if you need me to explain how the subquery works

Conditional formatting is then used to 'hide' the date values where the RankByDay value >1
As you can't actually hide fields using CF, I've made the forecolor the same as the form backcolor

Hope its useful to you

 

[JamesJoey]

So far so good. One thing though and it's not that important.
When I place the Reminder field below the ReminderDate by Day the space between the rows are large.

As you can see here. I can keep it with one row.