Showing Forms in Access Basic Conditional on Field Entry

[abrogard]

I would like to know how to write my Access prog so's when users are entering fields on an initial form they suddenly get presented with a different form depending upon what they enter in one of those fields.

So that, for instance, if they enter 'England' they get presented with a form asking questions about England and so on....

I'm very new at all this and ignorant of Access (you can see that?) and I wonder what it means if I do this:

If another form opens up to take in data must I close the last form?
Will the data on the last form be written into the data tables automatically on closing that form?

[Stewart Ross]

I think you'd need considerably more experience than you have already got to do what you ask, as you need to be familiar with database design in general, custom forms design and VBA code.

It is certainly possible to design a custom switchboard that presents different forms options to users depending on values in underlying fields or on user options chosen. For an example of how it is done you can look at the Switchboard builder that is supplied with Access, which creates a single blank form with option buttons, and all levels of switchboard that follow are built around this one form.

I'd suggest you work through examples in good 'how-to' books such as Building Microsoft Access Applications by John L. Viescas, as learning by doing is the only way you will build the experience to be able to set such things up.

-Stewart