Recent content by rasher

I have a search form that is continuous, and uses tbxEmployeeID to identify the records that are displayed with the criteria selected. I want to use: to display multiple records that are found in the data set, because the report I have cannot be linked with the other criteria (CertificationID...

That helped alot! I was able to create subreports for each one using your format, and it works great! Thanks so much. I guess I was just thinking too far into it.

Okay, so even with the redesign, when one employee has a different combination of skills, certifications and training, you end up with the same report issue where a person with 1 skill, two certifications and three types of training gives repeat values in the query where there would have been a...

That's exactly how I redesigned it, and it works! I just need to figure out how I'm going to represent the entry on one form (too much of a pain to use seperate ones), but that's not a big deal. I'll probably use tabs or an unbound form that writes to the table. Thanks alot!

Thank you very much. I am building a test database to make sure that approach will allow me to create the report correctly before I implement it in the main system. Logically, I think keeping track of them seperately will allow for the query, but we'll have to wait and find out. Either way...

They are not related, only by the employee that has them. Do you think I should normalize the EmployeeDetails table into what you said? I still want to be able to enter data all on one form, but I think I could do that with a combination of buttons and record sources. Just to make sure you're...

That worked great, thank you very much.

I have a skill/certification/training input system that revolves around one form which inputs any combination of a skill/certification or training that an employee might have. It records this in an EmployeeDetails table in the following fields : EmployeeID, SkillID, CertificationID, and...

I have four combo boxes (EmployeeID, Skill, Certification, Training), three of which must wait for an entry in the first to become enabled. The user is able to enter data on any of the last three, (e.g. a skill and a cert, just a skill, or any combination) in order to make a record. I have...

Thanks! I modified my code to :

My first post...I couldn't find help on this anywhere. I have a search form which uses a simple filter to display records and then print a report based off of those records. The user has requested to be able to click the Employee Name that is displayed (as a hyperlink) to generate a report...