question

cesarced-8021 avatar image
0 Votes"
cesarced-8021 asked cesarced-8021 commented

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.

office-access-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

thedbguy avatar image
0 Votes"
thedbguy answered cesarced-8021 commented

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?

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

i just have 3 tables
one where all the data from clients is stored, i have no relations on this table, is just that
the other two are for users and user permissions
i cant share screenshots because is sensitive info

0 Votes 0 ·

I was only hoping to see the field names, not the actual data. Can you share those?

0 Votes 0 ·

97682-tab.jpg


97701-tab2.jpg



The requirements aren't added yet, this table is being used for clients that doesn't need those requiriments

0 Votes 0 ·
tab.jpg (83.3 KiB)
tab2.jpg (47.3 KiB)