Access 2010 form help

[Andyjones]

Hi Could somone please figure this out scratching my head with it now



On the Match Date form when I select Home for match type and then enter player name score then opp player Name and score it should auto populate with 2 points if its an away home win and 3 points if it is an away win per player.

If my player points at home =21 then my player will receive 2 points and if my player away score is 21 then my player received 3 points.

It all works up until i delete the test data to start entering actual data, could someone take a look and try and figure it out please.
Attached Files

new test1.zip (383.8 KB, 6

[June7]

The points data looks like something that could be calculated as needed and would not need to be saved to table. Use this expression as ControlSource for the Points textbox: =IIf([OurScore]=21,IIf([Forms]![frmMatchdate].[frmMatchDateType subform].[Form].[MatchDateTypeID]=1,3,2),0)

If you must save Points to table then will need VBA code in some event. I'm just not sure which one will work best for your situation. I normally control something like this in a button that closes the form. I disable the X close on all forms.

[Andyjones]

OK I need the score to be saved in a table,.

[June7]

As I said, not sure what event but assuming you figure that part out and the Points field is included in the form's RecordSource, code in the event could be simply:

Me!Points = Me.Points