Hi. Everything starts with your table structure. Before we can provide any suggestion, we'll need to see your table structure. Can you post some screenshots?
Access 2016 how to register a list box in one form and show it on another form
I have two forms, one is used to record data in the table and the other is used to query.
I need to put 21 data on the registration form that are requirements of each registration, some registrations need only 7 of those requirements, other 3 requirements and others more than 10, I also need to show it if the registration does not meet one of the requirements. I want those requirements to be shown in the inquiry form but only the requirements that apply to the record in question.
how can I do it? I was thinking of a list box with 3 options (yes, no, it doesn't apply) but I don't know how to store that data in the table, nor how to bind it to the record or selectively display it in the query form.