I have three tables, one for client details, the other two are client reports and client visits.
They are related by ClientID, and thus are one to many (the one side being the client detail side).
I have a a main form, and two sub forms. The main form selects the client, and the two sub-forms select the latest report data and visit data. These two subforms are based on normal queries and work fine.
On my two subforms, I have a button whereby a user can 'add a new report' or 'visit' for a new month. This button in both cases is simply:
Private Sub NewMonth_Click()
On Error GoTo Err_NewMonth_Click
DoCmd.GoToRecord , , acNewRec
The problem is this:
When I click on 'new month' I cannot input data into the form. I can edit existing data that loads up but if i click new month it won't let me do it. Is this because of my relationships and 'joins'? Or is this because I don't have it set as an update query? Any help much appreciated!