Add Record (1 Viewer)

[mtagliaferri]

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

Private Sub CmdAdd_Click()
DoCmd.OpenForm "frmAirport", acNormal, "", "", acAdd
Forms!frmAirport.CmdEdit.Visible = False
End Sub

all these forms have as Record Source a specific table, I have one form that has as Record Source a query

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;

Unfortunately the Add command with the code above mentioned does not Add the record :banghead:
What am I doing wrong?

 

[Ranman256]

Sometimes, because of the joins, the query is not updateable.
fix by using a table, or query with less joins.

 

[mtagliaferri]

Uhmmm the form display all the information generated by the query, is there a way around it?

 

[Ranman256]

edit only the table, (but filter on the items you need)
Normally you enter data in a single table, not a query. (queries SHOW the table)
you cant enter into a RO query having that many joins.

 

[mtagliaferri]

So you are saying there is now way round this if the record source is a query?