Handling checkboxes, a question of style?

S

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?
 
M

Mike Brind

Sean S - Perth said:
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.
 
F

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
 

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

Members online

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top