Want to select components of Allen Browne's ConcatRelated() Function

[ScubaBart]

Don't you do inspections of a given hive, which belongs to an apiary? If that's true then your structure should be

Apiary--(1,M)--Hive--(1,M)--Inspection.

That is more or less correct. There is a relationship of one to many for the Apiary to the Hive respectively. When inspections occur, they are completed at a given Apiary so typically, multiple Hives at one Apiary are inspected. A different Apiary may not be inspected in the same day or even same week.

This leads into the other issue I am working on. On my Inspection entry form, I will select an Apiary. I will then add a Hive Inspection that chooses from the list of Hives located in that Apiary. I am so far, not able to make that drop-down work for some reason but that problem is unrelated to what I want to achieve here for the Main Overview Form.

If you think you can make my main form the way I am looking for, by all means, play with the relationships.

My goal is to get an appearance that would replicate what it would look like IF I could place a continuous forms subform into the continuous forms top level form.

Have at it.

[Welshgasman]

#15
That is pretty much as I would do it, for at least apiary and hives, but the issue here as I see it is a gui one?

[Welshgasman]

#17
What you are describing is generally called cascading combos, if you use combos for apiary and hives.

[ScubaBart]

#15
That is pretty much as I would do it, for at least apiary and hives, but the issue here as I see it is a gui one?

Yes, a gui issue but was hoping some coding would give me a satisfactory workaround. Seems not to be however.

[ScubaBart]

I would try and work with this...
(Picture removed)

Will make a copy and experiment with that when I get a little time. Got tasks and cleanup after getting dumped with over 4" rain from Debby yesterday.

[Welshgasman]

Yes, a gui issue but was hoping some coding would give me a satisfactory workaround. Seems not to be however.

Well you have been given one method by @Gicu?

[ScubaBart]

Well you have been given one method by @Gicu?

A method yes but not with the appearance I am seeking. Still, it may be what I end up with.

[Gicu]

Sorry for the delay, I've been hiking in Whistler for a few days and away from my laptop. I don't think you will be able to achieve your desired look even with code as you don't really have an event that triggers for all the records shown in a continuous form. Please read this thread for more details on this:
https://www.access-programmers.co.uk...s-form.129260/

The suggestion in the last post is as close to your vision as you will get, but the subform will appear below the apiary record not to the right. What I suggest is to have the apiary records listed in a continuous form on the right (using the apiary table only as the record source) and a subform on the right for the hives associated with the current apiary record, which is simply achieved by linking the two forms on the ApiaryID. You can then add code to the double click event of the apiary ID or name textbox on the main form to open a bigger single form showing the selected apiary details and associated hives and whatever other subforms you might want to include (inspections).

Cheers,

[ScubaBart]

Jus and FYI that I am ending this thread. The solutions presented while achievable, do not give me the desired results.

I am looking at alternative layouts and will likely post new questions as I go.

Thanks for all the input regardless.