Can a form be programmed to automatically generate within a field?

[GammieWen]

Windows 10
Access 2016

I am setting up a database for a local food pantry so they will be able to get everything computerized. I am fairly new to using Access and my question is this:



When in a field in a form is it possible to have another form generate based upon an answer within the field? Example: in one of the fields we have to list how many people are in the household under 18. If the answer is anything other than 0, can a form pop up that will enable us to enter all needed information? If this is possible, what is the best way to do this?

Just a side note: I do need to keep this as simple and easy as possible - some of the users are not computer savvy at all. So this needs to be something that can be navigated easily

Any help with this would be greatly appreciated. Thank you.

[June7]

Anything can be done with enough code. Keep in mind - 'the more user friendly, the more code'.

Sounds like you really need to complete some introductory tutorials to learn the basics of relational database concepts and Access functionality.

[June7]

Anything can be done with enough code. Keep in mind - 'the more user friendly, the more code'.

Your question is very broad and really not possible to provide specific answer as any approach taken depends so much on your data relationships and business processes and your skills.

Maybe a popup is not the best approach for your situation. Maybe should just do a form/subform structure.

Sounds like you really need to complete some introductory tutorials to learn the basics of relational database concepts and Access functionality.

[Micron]

To elaborate on the answer given, you are likely going to need to use the AfterUpdate event of the text box or combo box that contains the user input or a value chosen from a list. This you would do via vba code or a macro, but most of us who answer here don't use macros so vba would be our method since it is more powerful and reliable. As for your users, they would not know the difference as long as your method functioned well.

However, the answer implies that you need to delve into aspects of Access design that are likely foreign to you and I would agree on that. It is quite likely that what you should be doing is revealing a hidden subform, or perhaps just revealing hidden form controls for the user to enter data into, depending on prior input. How easy it is for the user to navigate is very much the responsibility of the designer, and that is you. To increase your chances of success in this regard, you should research Access design as much as possible. There are tons of videos and information sites out there.