Originally Posted by
ssanfu
You could post your dB for analysis.......
I think this is what I need to do. From everything that I read through in your answer, I am doing it right, but I have to be missing something!
--------------------------
So, here goes:
My issue is with the Form: Enter Freestyle Results. In the Combo Box for leg?, I want the user to be able to see what # of legs has already been entered for that dog, in that Division.
I want to see the Division description, not the ID# in the Combo box. (the way it is set up in the Query)
The field that should fill in is the 'Max of Legs' and the User needs to be allowed to change that.
Essentially, I am using the Query and the Combo Box to give the User information about previous entries in the table. They need this info in order to fill in the correct # of the leg at this time. (i.e. in most cases, 3 legs are needed in order to get a Title and progress to the next Division). Maybe there is a better way to accomplish this?
https://dl.dropboxusercontent.com/u/...ws2Dance.accdb
Any help would be gratefully accepted! I am at my wits end with this!
Lin