Form-subform from listbox

[TRexMedic]

All right all. I am probably completely over thinking this, but at this point it is time to consult the experts. One thing to keep in mind is that I am very new to access.
I am in the process of creating a DB for my fire department. I am tracking our training among other things in the DB. However, I am focusing on the training for this thread. I have created a table for each firefighter for training as well as a table for the overall roster. I have created a listbox on a form that pulls first name, last name, rank, and training file name from the roster table.

Here is where I get lost. Once I select the firefighter from the listbox, I want it to pull the first name, last name, and rank from the Roster table an populate a form or report with this information. Then pull the data from the firefighter's training file and populate a subform or subreport under the previous information.

any assistance would be GREATLY appreciated.

[June7]

"table for each firefighter for training" - do you really mean a single table with all firefighters training?

If you want to provide db for analysis, follow instructions at bottom of my post.

Example of a "search" form http://allenbrowne.com/ser-62.html

Training database is a common topic, review
https://answers.microsoft.com/en-us/...2-ed56fa461560
https://access-templates.com/tutoria...ms-access.html

[Salty Mariner]

All right all. I am probably completely over thinking this, but at this point it is time to consult the experts. One thing to keep in mind is that I am very new to access.
I am in the process of creating a DB for my fire department. I am tracking our training among other things in the DB. However, I am focusing on the training for this thread. I have created a table for each firefighter for training as well as a table for the overall roster. I have created a listbox on a form that pulls first name, last name, rank, and training file name from the roster table.

Here is where I get lost. Once I select the firefighter from the listbox, I want it to pull the first name, last name, and rank from the Roster table an populate a form or report with this information. Then pull the data from the firefighter's training file and populate a subform or subreport under the previous information.

any assistance would be GREATLY appreciated.

I created something very similar to what you are tying to do with a form for my crew and a subform for their "documents" many of which are training certificates. You should be able to accomplish this with 3-4 tables here is a snip of my relationships.




I have a form for my crew and a subforum for their documents with conditional formatting to show expiring within 90 days, 30 days and expired. I don't allow editing on the subform but have the user double-click on the document name to open a another form that allows for new records and edits. when that form closes it requeries the calling form to update the record. See below for the main form and the document editing form.


Substitute "firemen" for "Crew", and "Training" for "Documents" and something like this sounds close to what you are tying to do.

BTW, you posted this question of Forms in the Reports forum.

[Bulzie]

Nice DB there Salty, you need to bump that Novice tag up some .

[Welshgasman]

Don't expiry dates tend to be 1 day less that the start date plus the duration length?

IE 04/22/2022 would expire 04/21/2026

[Micron]

I'd say it depends on one's interpretation of expiry. If you have a coupon that expires 10/31/2023 you can usually use it up to close of business on that day. It doesn't expire the day before at close of business. At least that's how it is over here.

[Salty Mariner]

Don't expiry dates tend to be 1 day less that the start date plus the duration length?

IE 04/22/2022 would expire 04/21/2026

In the case of the example that I posted those dates were pulled directly from what was printed on the crewman's certificates. Some certificates only have a date of issue. while others have both a DOI and DOE. and still others only list an expiration date. The best we can do is to take verbatim whatever is typed on someone's certificate.

[Welshgasman]

I'd say it depends on one's interpretation of expiry. If you have a coupon that expires 10/31/2023 you can usually use it up to close of business on that day. It doesn't expire the day before at close of business. At least that's how it is over here.

Yes, that is how car isnurance works over here, but it would have started on 11/01/2022.

However, if that is what is on the certificate, that should be used. Still not sure they did their math correct on that though?
A common mistake (IMO) that I have seen countless times.