mtagliaferri
Registered User.
- Local time
- Today, 07:33
- Joined
- Jul 16, 2006
- Messages
- 519
I have a some nice forms contained in a navigation form, all these forms have an Add button to add records with the following code which works perfectly
all these forms have as Record Source a specific table, I have one form that has as Record Source a query
Unfortunately the Add command with the code above mentioned does not Add the record :banghead:
What am I doing wrong?
Code:
Private Sub CmdAdd_Click()
DoCmd.OpenForm "frmAirport", acNormal, "", "", acAdd
Forms!frmAirport.CmdEdit.Visible = False
End Sub
Code:
SELECT tblCrewMember.StaffNumber, tblCrewMember.Surname, tblCrewMember.Name, tblCrewMember.Position, tblCrewMember.Base, tblCrewMember.Nationality, tblCrewMemberTimeline.TimelineDate, tblCrewMember.Resigned, tblCrewMember.ResignedDate, tblCrewMember.DOB, tblCrewMember.Gender, tblCrewMember.CrewType, tblCrewMember.CallSign, tblCrewMember.MaidenName
FROM (qryCrewMemberTimelineFirstRecord INNER JOIN tblCrewMemberTimeline ON qryCrewMemberTimelineFirstRecord.MinOfIDTimelineCrewMember = tblCrewMemberTimeline.IDTimelineCrewMember) INNER JOIN tblCrewMember ON qryCrewMemberTimelineFirstRecord.IDCrewMember = tblCrewMember.IDCrewMember
ORDER BY tblCrewMember.StaffNumber;
What am I doing wrong?