if I click on AddRecord button, the new form doesn't load "Requested by:
That is easily fixed. You just need a bit of VBA code in the On Current event of the form:
Code:
If Me.NewRecord Then
[RequestorID] = CurrentUser_ID
End If
This code runs every time you move to another record in frmRequestTraining. If that record is a new record, then populate the (hidden) control [RequestorID] with the current user number. The "Requested By" control will automatically show you the resquestor's name. A record can only be "new" once, so if another user views the data in that form, the user ID's will not change.
Another question I have is with frmTrainingRecord, right now information from frmTrainingRequest is not passing onto it
The only field the two forms have in common is the TrainingRequst_ID. If you make the bottom field (TrainingRequestID_FK) a combo box listing the uncompleted training requests, and bind that combo to the TrainingRequestID_FK field in tblTrainingRecord, that will be the link you need. If you want to display other data from the corresponding training request, it is not difficult - you just need a few unbound textboxes on the form, or maybe a popup read-only form.