Yeah, it clears when I update any of the combo boxes, but initially there is information in the subform, which ideally should be removed. Maybe assessor name (and the AssessmentDate and ReviewDate) should just default to null?
Yeah, it clears when I update any of the combo boxes, but initially there is information in the subform, which ideally should be removed. Maybe assessor name (and the AssessmentDate and ReviewDate) should just default to null?
On the main form, add this code in the "OnLoad" event:
DoCmd.GoToRecord , , acNewRec
The reason is that when you open the form it reads the first record from your record source, TblAssessment and populates the AssessorID from the first record on that table.
it still briefly attempts to show data, but it'll do - thanks for all your help
Can't say that I see that, maybe you have a faster connection than me!
I wouldn't have thought so, this machine is pretty old... Still, it works so I'm happy
Out of curiosity, do you think the subform method you mentioned here, will work for my problem on the AddLowRiskAssessment page? Thread available here: https://www.accessforums.net/showthread.php?t=62079
From a brief look, I would think that the scenario's are identical: select Behaviour from a combobox (as AssessorID) and display it's data.
This may have one small difference, however, the user would want to see the behavior data before they make their selection, not after? In which case a list box might be nicer.
Well ideally all of the behviourIDs would be displayed, not just those which are selected - so I was thinking of using a text box (which is locked) - as opposed to a combo box, and the rest of the fields are displayed in the subform.
Actually, now I think about it, I might be able to just put it all in one subform... I'll have a crack at it next week.