Can i send you the file so you have a look at it and let me know where Im going wrong
Thanks Im uploading now but its a slow connection....
When you open it if you click on the "exercise program" thats where im stuck. If i choose a client in the first box it displays it in the box at the bottom which is designed for a second client. The S1 S2 sections are the exercises they complete this is not working either.
Thanks I found where to change the form style how do i now add multiple clients at the one time.
Sorry confusion, can I add multiple clients and see all the details before saving, like before when i had the tabs.
Ok now I'm lost, thanks anyway for your time....
yes please if you could do a basic shell i may be able to understand it.
Thanks Richie I think this has answered my question I need to make a form with all the info on it and then create a subform. Its late here where Iam and need some sleep so I will have a look tomorrow, thanks for all your help, and just a quick one and I can get further help later. Can Access do scheduling.... Cheers XXXXX XXXXX again. Damien
Morning Richard, I can't seem to add data it returns an error that it creates duplicate values.
Ok so I need a way that the form is blank when it opens and I can then save after putting details in. Also how much would it cost roughly for a company if there are any to complete this to a working level.
ok maybe this approach is not right then, If Im working with multiple clients at the one time I need to add the exercises they do as we do them. Is there a way of doing this or do I need to work on a different method.
ok so there are multiple trainers and multiple clients
1 trainer can train up to 3 or 4 clients, from these clients they may all do the same exercises in which weights will need to be recorded or 1 client may do different exercises.
my thought was i choose the clients i choose the trainer, date and exercises then when the session is finished i hit record or save and then it clears the selections ready for the next session.
Does this help
Yes this is what the S1,S2 tabs were all about and thats what i was enquiring about the scheduling, as it would be handy for the system to tell us what the next session for that client is.