Multiple checkboxes in a form

[dedjloco]

Oke this should be pretty easy, but I'm search for hours now and haven't found the right solution jet.

I have 3 checkboxes in a form and 3 records with checkboxes in a table. The table and the form are coupled. And you should be able to check multiple checkboxes.
I just want the link the checkboxes to each other. so that I can use this data later on.

 

[sneuberg]

3 checkboxes on the same form will not display values from 3 different records through the normal binding. You could use DLookup but I think there's probably a better way if you explain more about what you are trying to do.

 

[dedjloco]

I want to make an application to to give a score dependig on which option you check, on a product. so the checkboxes what is was talking about are the first option, but you can have multiple option in some cases. the scores are stores in a table because they could change in time.
so if you gone though all the options, you will get a score on how interesting it would be to sell this product.

I cant really tell the specifics because this is valuable information.

 

[sneuberg]

Without specifics it's hard to advise but I would guess you need a table of the products and then a related table of questions which could have checkboxes For example if the product table had
Product ID | Product Name
001 | Grandma's Lye Soap

Then a related table might have

Question ID | Product ID | Question | Answer
001 | 001 | Cleans Ears Well | True
002 | 001 | Does It Suds or Foam | False
003 | 001 | Cleans Ulcers | True

with this structure you could count the True answers in an aggregate query.

 

[dedjloco]

I don't think this is what I want. I should say that I started working with access yesterday so I'm still learning.
I think you can compare what I want with if youre buying a new car and selecting options like navigation and so. And then at the end they give you a price. that is sort of the idea.