Form help (1 Viewer)

yammers4

Registered User.
Local time
Today, 05:19
Joined
Feb 25, 2012
Messages
19
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.
 

Attachments

  • new test1.zip
    383.8 KB · Views: 173
Last edited:

bob fitz

AWF VIP
Local time
Today, 05:19
Joined
May 23, 2011
Messages
4,726
Can you attach a copy in A2002/A2003 (mdb) format.
 

yammers4

Registered User.
Local time
Today, 05:19
Joined
Feb 25, 2012
Messages
19
unfortunatley not i used access 2010
 

bob fitz

AWF VIP
Local time
Today, 05:19
Joined
May 23, 2011
Messages
4,726
If you haven't used features that were not availble in the earilier version, then you may be able to convert it to an earlier version. Take a look on the menu bar for something like <Tools> <Database Utilities> <Convert>
 

yammers4

Registered User.
Local time
Today, 05:19
Joined
Feb 25, 2012
Messages
19
ive tried before but the features I use do not work in any other version that access 2010 thats why I asked for access 2010 users.
 

yammers4

Registered User.
Local time
Today, 05:19
Joined
Feb 25, 2012
Messages
19
OK I apologise i didnt lol but it access 2010
 

Users who are viewing this thread

Top Bottom