Handling checkboxes, a question of style?

[Sean S - Perth, WA]

Hi all,

I have an edit form for records that belong to numerous categories. Records
are joined to categories with a join table in a many-to-many relationship.

When displaying a record for editing I loop through the category recordset,
looping through the entire join-table recordset for each category, to tick
(or not) each checkbox as it's displayed.

This seems like a costly way of populating checkboxes.

Is there a more elegant solution?

--
Sean.

[Mike Brind]

"Sean S - Perth, WA" <Se**********@discussions.microsoft.comwrote in
message news:EB**********************************@microsof t.com...

Hi all,

I have an edit form for records that belong to numerous categories.
Records
are joined to categories with a join table in a many-to-many relationship.

When displaying a record for editing I loop through the category
recordset,
looping through the entire join-table recordset for each category, to tick
(or not) each checkbox as it's displayed.

This seems like a costly way of populating checkboxes.

Is there a more elegant solution?

That's the way I do it, except that I use GetRows to put both recordsets
into arrays. Then I do my looping.

--
Mike Brind

[Firas]

Hi, i really wish to help you.
But could you please explain more about what you are doing and what do
you want to be done?
Best Regards

On Oct 12, 11:51 pm, Sean S - Perth, WA
<[e-mail]:

Hi all,

I have an edit form for records that belong to numerous categories. Records
are joined to categories with a join table in a many-to-many relationship.

When displaying a record for editing I loop through the category recordset,
looping through the entire join-table recordset for each category, to tick
(or not) each checkbox as it's displayed.

This seems like a costly way of populating checkboxes.

Is there a more elegant solution?

--
Sean.