Recent content by esturgesjr

DHookom: All training is currently stored in separate tables linked by ID. As for data stored in Personnel, see my explanation to Mike as to why some info must be kept within Personnel.

Mike: Thanks for the suggestions! Start/Termination Dates, Unit and Position must be stored in Personnel. They are dates specific to one person and usually don't change (Start is equivalent to Hire, Unit is the person's radio call sign and Position is whether the individual is Interior or...

Thanks for picking that duplication up, isladogs! I guess these feeble eyes missed that multiple times! Fixed! DHookom: as for "storing data", you'll need to be more specific so I'll know what to zero in on. Thanks all, for your input. I may be old, but I'm still learning!

Here's the SQL behind the form; didn't see anything in here that jumped out. The training is in a separate table as you'll probably see in the code. I'll try recreating the form. Thanks! SELECT Personnel.AFD_ID, Personnel.[Last Name], Personnel.[First Name], Personnel.Email, Personnel.Phone...

Just when I thought I'd seen everything, I get this .... the yellow highlighted field should be the field in the list circled in red. Totally unsure how this error came about. I delete the field from the form and replace it with the correct field (the errant field stays in the Field List) and as...

Ugh, a slight problem. When I run the above code (which is running from the AfterUpdate on the Main Form), the subform is NOT refreshed. I know the records have been written to the table as I see the record change in the Navigation bar, but the form stays empty. If I navigate back one record...

Bingo!! Thank you ALL for your input; many lessons learned (as always) from the gurus, some of which I have leaned on from UA (you know who you are). Here's the final code: Private Sub cboTrnType_AfterUpdate() Const MESSAGE_TEXT = "A training date must be selected." Dim strSQL As...

The ID (AFD_ID as JR_ID) should be obtained from Personnel, not JR_TrClassesT (see Post #20).

Hmmm, either I didn't explain the situation properly or you misunderstood the post. I am attempting to grab the 12 Juniors from the Personnel table (no duplicates here, 1 record for each member including the 12 Junior members) and create new records for a specific training class in JR_TrClassesT...

Ken, moving right along, then I stumbled when I modified code to include my needs (see screenshot)! Compile error; expected end of statement.

Thanks, Ken! I think this will "fit the bill". I'll dive in after I've had my morning coffee (yeah, it's 9:41 am my time, but I'm retired ... ha ha). I'll report back when I have an update.

Thanks, arnelgp! I appreciate the work you put into this; however, your code returned 609 records instead of the 12 I'm looking for (it returned all records from the table JR_TrClassesT except for 28 records attached to a Junior who resigned earlier this year). I only want records from Personnel...

Thank you, Ken. The subform is a datasheet view of a table (JR_TrClassesT) so I guess the answer to whether it's bound or not is "yes". The JR_ID would come from Personnel table (AFD_ID) where the Rank = 'Junior Firefighter" and Status = 'Active' and Order by LastName, FirstName; the TrnDate and...

Thanks for the replies. This is a form that I was filling manually. I manually enter the ID in column 1 from a sign-in sheet supplied by the Training Coordinator, I have a DLookup in column 2 that pulls Last Name and First Initial from the Personnel table (to make sure each check box in column 3...