Form used to select records from one table, then use this to add records to another table

[Heathey94]

Here's the database for reference.



Thanks for all your help by the way, I know I'm not particularly great at explaining what's going on.

[aytee111]

Don't tell me - you're going to mark this as solved? Hallelujah!

Come back any time!

[Heathey94]

Not quite yet, sorry - I still don't know why my subform isn't updating

[aytee111]

What does that mean exactly? Please be more specific.

[Heathey94]

So I select a behaviour in the combo box (where you had a list box) and a message appears:

If I click yes, it creates a new row in the AssessmentDetails table, but the subform stays the same.

Please use this database, the one I uploaded previously had the event in the wrong section.

[aytee111]

This looks like the old database, the form is no different to the old one.

Those messages are found in the File>Options>Client Settings>Confirm

[Heathey94]

How is my form different to yours though? I can't see why yours works and mine doesn't.

OK, thanks.

[aytee111]

Me either! I put my subform in and it works perfectly, I put yours in and it goes belly-up. Go thru the properties of both forms, there is a difference somewhere

[Heathey94]

Well at least that narrows it down to a problem with the subform... right?

I'll have a browse

[aytee111]

I went thru all the properties of both subforms - made yours the same as mine and it works!

[Heathey94]

Allow. Data. Entry. Pretty sure that was the problem. Wow, thanks for your help!

[aytee111]

I don't know why you only allow them to see one record at a time, that isn't very user friendly! What if they are disturbed during entry and forget what they have entered? There is no way for them to check what has already been entered. If they are only allowed to enter one then the subform should not be a continuous form.

[Heathey94]

I've just made it bigger - I wasn't sure how big to make it at first.

[aytee111]

I know you hate scroll bars, but that is what they are for! Put vertical ones on the subform.

[Heathey94]

Just done it

Out of curiosity, is it possible to stop a user selecting the same behaviour twice on the same assessment?

And if a box is ticked in Assessment or third party intelligence, it is present, so I'd like that to automatically fill in - that or the second two boxes are not enabled until present is ticked, are either of these doable?