Search results for query: *

hi all sorry for the delay i have been away for the week tomthumbuk: your statement is totally correct. Leslie: the setup is basically correct. I only record the details of one club Padiham Town. i have tblmatch MatchID HomeTeam ( this is set to PTFC and never changes) AwayTeamID other stuff...

TomThumbkp I dont think we are thinking the same. I dont think i am clear enough. For every match the club plays it creates a record. Within each match it creates a record for every player that plays a match. hence 16 records. I want it to select one individual record to be the man of the match...

yes it is

could you tell me what the code is

i cannot get it to work that way. can you show me the other way cheers

Your method works the way you have stated but it does not do what i want. I have 16 records on a subform. i want 1 0f those 16 records to be man of the match the form is set out like this P= Played S= Sub Y= Yellow Card R= Red Card M= Man of the match P S Y R M Player1 YES...

What happens when i make that option group is on every record it will be the same. e.g Player 1 yes player 2 yes and so on what i want is something like this player 1 no player 2 no player 3 yes player 4 no player 5 no i think the coding way will work. any suggestions for the code Thanks...

Hi LesPaul, I think that is what i need. I have produced code for another field. It checks whether a player played in a match or was a sub in a match. Private Sub Apps_Click() If Me.SubApps = True Then MsgBox "You cannot be a player if you are a sub!" Me.Apps = False DoCmd.CancelEvent End If...

Any suggestions would be great Thanks

Thanks TomThumbKP Sorry in such a delay in replying. I have tried that method and it does not work. If select yes then all the boxes say yes. Is there any other suggestions. All i want is one player of a squad of 16 players to be the man of the match. Once a player is chosen to be man of the...

i will try that. Thanks for your help i have to go now i will let you know in 3 or so hours

Sorry its me. I did not select the correct option. Found it now. Could you make some suggestions about what i should do with the wizard

i have tried that but the wizard does not open

I dont think i need an option group. because Each player who plays in the match has the choice to tick the man of match field. This means that they could be 16 records which have the man of match field ticked. I want the system to allow only one record to have the man of match field ticked. I...

Could you tell me how to put the man of match checkboxes into a control group

Hi all this is my first post. I have designed at football club database for my friend and have I slight problem with a check box. On the match form it contains details of who, when, where the club played a match. On this form I also have a sub form to allow a match day team to be entered. It...