Recent content by ka3pmw

That worked. THANK YOU VERRY MUCH for all of your help and patience. It's not fun getting old!

I tried that and I can not get it to behave. Once I change a value, it keeps that value all the way through till I change it again. I am using No for the first value and default to do as you said and avoid blank records.

I decided to go back to the old way of entering the MARS from a listbox to eliminate being able to select multiple values. The only problem I am having with that is that when I select it for one person, it copie3 that value to other people. Not Good! Any Ideas? It used to work.:banghead: I...

Perfect, works like a champ. Only one problem. You can still select more than one value for MARS. A person can only belong to one MARS branch at a time.

OK, I have everything done except the MARS and Affiliations problems. You had said something about using something like: RosterID > 8 ~ AffiliateRef 1 RosterID > 8 ~ AffiliateRef 3 RosterID > 8 ~ AffiliateRef 4 RosterID > 8 ~ AffiliateRef 7 I don't follow what you are saying. I have the...

Ok, that is what was confusing me. I had too many questions going at onse. Will do but not sure how soon I will get to it. May be a couple of days.

I have that working. what I need now is the answer to my next question, the list length.

Never mind this. I got it working!! :) Now for the next problem. I need to limit the number of selections in the MARS and Affiliation boxes and prevent duplications in those boxes. There are three possible entries for MARS, and seven for Affiliations. I need the choice list to allow...

Both the report and the query. I don't care so much what is shown on the query, unless I have to have the info there for the report, but the report is what is important. The new license classes are Tech, General, and Extra (The FCC combined the old ones but some people still have the old...

Ok, I did and it sort of works. There are three problems left. The one that is keeping it from being usable is the License Class Report so let's look at it first. When I do the query or report, I am getting a number instead of the name of the class and the total count for that class. The total...

Ok, I created AffiliateIndex in the Affiliate table. Next step?

Ok, I'm missing something here. I created a field in the affiliate table called AffiliateIndex. Now I need to create a relationship to the roster table? I suggest we take this one a step at a time.

Never mind this one. My fault. I had the control Wizard on when I designed it. Mt Bad! I set 4 fields, No, Air Force, Army, and Navy. That way there are no blank fields.

Are you saying to add a new index or one that already exists?

tblRoster the tblMars line I added and the frmRoster has them listed too.