create new entry field when current one is in use

[enginerdUNH]

Hi,

I have a question regarding creating a basic "dynamic form" if you want to call it that. Basically, I am creating a database to be able to store information on the individuals who volunteer for my fire department. I have a form where the members enter in their basic information and demographics and then click on a command button which brings up a pop up form to enter in any certifications that the individual has. What i am looking to do is create a form that will work similar to how tables work where as soon as you start entering in information in a particular row, a new row appears. Then you can enter information into that row and a new row again appears, and so on. I want to do the same thing but with a form. When someone opens up the form for the first time, only one "record" spot appears and it's blank. When they start to enter information into the first record spot, another record line appears for them to enter their next certification once the last entry is complete. This continues until all entries are entered. When the person opens the form for a second, third, etc. time, all previously entered entries will appear all on one page. I want to do it this way rather than have all new entries appear on different "pages" of the form. Each record on that form will be tied to that member's ID number so that when a different member opens up the form to enter their certifications, a new record is created that is tied to that different member.



I appreciate any insight that anyone can give me on how to make something like this work.

Morgan

[June7]

Think you should look at building a form/subform arrangement.

[enginerdUNH]

Think you should look at building a form/subform arrangement.

How does this work and how do I do it?

[davegri]

How does this work and how do I do it?

VolunteerCertification-v1.zip
Here's a bare-bones example to get you started.
2 tables, tblVolunteers and tblCertifications with a form/subform setup.

[enginerdUNH]

VolunteerCertification-v1.zip
Here's a bare-bones example to get you started.
2 tables, tblVolunteers and tblCertifications with a form/subform setup.

I took a look at your example form and it's not quite what I'm looking for. The form that I have for member information has a button which pulls up a pop-up form to enter the certfications. The pop-up form is tied to the latter by a member ID which will also be used to separate the different certification records to the corresponding members. I would like the certification form to look like a regular form, where I have separate entry boxes bound to a certifications data table that the individual can enter the information in like a regular form but it acts like a table in the sense that when a record is being entered, a new blank record appears underneath. In other words, all records are stored on one "page" rather than having to go to a new "page" to enter a new record. If i have to design the form to appear like the individual is entering the information directly into the table that the form is tied to then I will, but this is not ideally how I would like it to occur.

[June7]

I still recommend you use form/subform arrangement. Set the DefaultView property to Continuous and AllowAdditions property Yes for the form used as subform. Should see the behavior you describe. It really simplifies creating related records. No code is required.

[orange]

Morgan,

Google can be very helpful for finding articles, posts and videos on various subjects.
Davegri offered a sample to show general concepts. It is unlikely there is an already available database that meets your needs.

I can assure you that getting your tables and relationships designed to meet your business need is a very critical first step.
Your perceived user interface is secondary to table design.

Good luck with your project.

[davegri]

I'm having a bit of trouble visualizing your proposed form, but here are some elaborations on the former db in Post #4
VolunteerCertification-v2.zip