Hopefully simple, trying to create tickable boxes on a form when a postal address is selected

[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.
But functionality to it yet.

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

Kind regards.
Access junior.

[June7]

Could have a yes/no field in table but that is not practical with multi-user database because users will interfere with each other. Another option includes multi-select listbox and vba code to build criteria string or to write records to table.

Are you selecting these questions and saving to a dependent table that associates address with selected questions? Could just do data entry and select a question into a new record of this dependent table via combobox.

[isladogs]

Cross posted at: https://www.access-programmers.co.uk...d.php?t=303560 and https://www.utteraccess.com/forum/in...ic=2052400&hl=

OP is new at all 3 forums. Standard link about cross posting added at AWF

[SkillipEvolver]

Could have a yes/no field in table but that is not practical with multi-user database because users will interfere with each other. Another option includes multi-select listbox and vba code to build criteria string or to write records to table.

Are you selecting these questions and saving to a dependent table that associates address with selected questions? Could just do data entry and select a question into a new record of this dependent table via combobox.

That last paragraph sounds good, would you be able to help me do that? I'm not sure how

See, what this guy did here: https://youtu.be/dEaQIrw3CZY
It looks good, I understand how he creates the yes/no options (by creating a field in the table),. But I'm not a fan of the record seeking (tiny buttons at bottom of form), I need to be able to select an address from a drop down list ideally.

[pbaldy]

Post 4 was moderated, I'm posting to trigger email notifications.

[June7]

That last paragraph is just building appropriate related table and form/subform arrangement for data entry.

At least 3 tables involved because this is a many-to-many relationship.

Addresses

Questions

AddressQuestions

[SkillipEvolver]

Hmm, okay. I'm not too sure how to set that up, do you think there are any quick guides for your suggestion? I've never made more than 1 table in Access so far! Let alone anything nested.
I'm sorry I sound so lame, I'm a long time out for using Access and I've bitten off more than than I can chew in the job. If there's any guides on this I would love to find out more.

[June7]

Many on-line tutorials on relational database principles. Any Access introductory book should cover the basics.

[Gicu]

Can you have a look and see if that is what you are after?

Cheers,
Vlad

[SkillipEvolver]

Hey Vlad, a great many thanks for messaging. I'm on my phone right now, but I can't seem to download any attached files on your post. I've tried switching chrome (mobile browser) into desktop mode but the site fails to load. I'll try again on my desktop at work but would.you be able to make sure it's properly attached? Forgive me if I've got something wrong here but in panicking a bit as i need to try and get this right today at work.

[June7]

Downloads for me.

[SkillipEvolver]

I'm hoping it's because I'm on my phone. If it works for you on a desktop I should be okay. How does it look?

[SkillipEvolver]

Im not sure I quite understand the terminology and so I don't know quite what to look for,. Does anyone have a particular YouTube link or tutorial for this task? I'm just stressing because I'm supposed to try and get this done today

[SkillipEvolver]

Thanks vlad, it looks pretty good! It's pretty much what I need!!
one final thing I;m trying to do though, is create a drop-down list on the Form, so I can select an address from the list instead of having to cycle through the records at the bottom of the form using Access's record seeking buttons. Do you know what I mean?

[Gicu]

Just use the built in combo box wizard to do that for you, it takes a minute and the satisfaction is great. If you are committing to using Access is time to roll up the sleeves and learn a few tricks .
https://support.office.com/en-us/art...b-b0f71a90c329

Cheers,
Vlad