Hopefully simple, creating a form with tickboxes relating data in a table (1 Viewer)

[SkillipEvolver]

Hello everyone,
Massive newbie here. I've used access about 15 years ago but need to get going quick on something. I'm not one to skip learning but in this case I need to find an answer fairly quick, and hopefully it should be an easy one for the experts here.

* I have a table in Access containing 160 postal addresses in cells (vertical, obviously)
I need to create a form which staff members can use so that.. when they select an address from a drop down list (already sussed that bit).. they can then TICK a series of questions relating to the address.

In my scenario, I'm working on a a database containing addresses and certain criteria they need to pass: eg:

House has smoke alarm?
House has safe ventilation?

All of these questions I want to make tickboxes for (or yes no answers, but ideally ticks as it's just a bit more visual)

So I understand that each of the 160 addresses therefore has records attached to it (or the series of questions)

How do I go about making this work?

So far all I've done is designed a form with the questions and made a working drop-down accessing the addresses but there's no functionality to it yet.

Any help greatly appreciated!!
Really need some help! Job may depend on it! (Seriously!)

Kind regards.
Access junior.

 

[Uncle Gizmo]

Hi Access junior,
I did a whole set of videos a while back on how to create a checklist in MS Access you can find more information about it on my blog here:- How to add a Checklist to MS Access

 

[Ranman256]

Ticks are ok , but could be a design problem later on.
instead how about a table of the criteria:

tItems table:
[Item]
Smoke alarm
Safe ventilation
CO detector

THEN the user can just add this as a child table to the address with a simple Dbl-click.
THIS way you can add/subtract questions just by adding it to a table, whereas if you use Ticks, you must re-design all forms and reports.

 

[isladogs]

Cross posted at: http://www.accessforums.net/showthread.php?t=75474
and https://www.utteraccess.com/forum/index.php?showtopic=2052400&hl=

You are new to all 3 forums and may not be aware why it matters.
Please read this link about cross posting: https://www.excelguru.ca/content.php?184

 

[SkillipEvolver]

Hi, what you've got in that screenshot looks pretty cool.
I can imagine something like that working for me, where you've got those people's names in that list, I could see that being full of postal addresses.

But where are you getting these double clickable selections from? I cant see where they're coming from?

I don't want to overcomplicate things and get into a mess. I take what you're saying about not having to redesign anything later on and your suggestion looks impressive but for now, if I was to ask if you would kindly send me that file? I don't want to risk lots of errors tinkering with things I don't know about. So I went to keep it simple for now

 

[MajP]

https://www.access-programmers.co.uk/forums/showthread.php?t=303125

This demo shows possibly two methods. One is a multiselect listbox, the other is a form with checkboxes to select values.

 

[MajP]

Sorry that was the whole thread.
https://www.access-programmers.co.uk/forums/showpost.php?p=1605243&postcount=10

 

[AccessBlaster]

Here is a link showing why it could be a bad idea to use check boxes.

http://allenbrowne.com/casu-23.html

 

[SkillipEvolver]

Ticks are ok , but could be a design problem later on.
instead how about a table of the criteria:

tItems table:
[Item]
Smoke alarm
Safe ventilation
CO detector

THEN the user can just add this as a child table to the address with a simple Dbl-click.
THIS way you can add/subtract questions just by adding it to a table, whereas if you use Ticks, you must re-design all forms and reports.

View attachment 73653

Would you be willing to send me a copy of that file at all? I know it's a bit cheeky to ask?