Tabbed Form Problems

[aadebayo]

Hello

I have created many sub forms to a main form. I access these sub forms via tabs. The main form diaplays full details of a Job Applicant and the sub forms display other information about an applicant.
Now one of the sub forms is the posts that the applicant has applied for. When I first clisk on this subform, it displays the posts that the applicant has applied for. If I return to the main form and go to the next applicant, then go to the posts sub form, it does the following
1) It retains the total number of Posts of the previous applicant.
2) If the previous applicant has 2 posts and the current applicant has 4 posts, I can only see a maximum of 2 posts.
3) If the previous applicant has 4 posts and the current applicant has 2 posts, the record numbers show that the current applicant has 4 posts, however, when you click on the next record, it stops after the second post record.

Please can anybody help?

Ade

 

[maxmangion]

try requerying your subform.

 

[aadebayo]

re:

This is the query of my subform

SELECT tblPostApp.*, tblPost.PostTitle, tblPost.ClosingDate, tblPost.DatePostFilled, tblPost.LowerAgeLimit,
tblPost.DateTimeStatsCompleted, tblPost.DateTimePaperworkSent, tblPost.DateTimePersonalSent,
tblPost.ContactName, tblPost.DisclosureLevel FROM tblPost Left Outer JOIN tblPostApp
ON tblPost.PostNumber = tblPostApp.PostNumber INNER JOIN tblApplicant ON
tblApplicant.ApplicantID = tblPostApp.ApplicantID

tblApplicant and tblPost has many to many relationship,
tblPostApp resolves that many to may

The filter is tblPostApp.ApplicantID =[frmApplyPost]![ApplicantID]
where frmApplyPost is the main form

 

[KenHigg]

I would guess there is a pk/fk issue with the posts table...

???
ken

 

[aadebayo]

Update

I have gone through the code again with a colleague and these are our findings. Below is the code

Form_sbfPostApp.Requery
Me.txtTotalRecs = Form_sbfPostApp.Recordset.RecordCount
Me.cmdMultipleSearch.Enabled = False
Me.cmdNoprint.Enabled = True
Me.cmddelete.Enabled = Me.cmdEditRecord.Enabled
Call glrEnableButtons(Me, Me!sbfPostApp.Form)
If Me.txtTotalRecs > 1 Then
' MsgBox "Third total record is " & Me.txtTotalRecs & ""
Call glrTglNavButtons(Me, True)
Else
Call glrTglNavButtons(Me, False)
End If
If frmAddNew Then
frmAddNew = False
fATnewpost = True
Me!sbfPostApp!PostNumber.Locked = False
End If

we realise that the recordset for Form_sbfPostApp isn not being updated onve the first Applicant details have been entered. Please can anyone tell me a reason why recordset will not be updated with new record count