Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Conditional Control Source in a Form
Thanks MajP. I didnt even think of doing that. That seems like a really simple solution. I'll try it out.- PPICKENS
- Post #8
- Forum: Microsoft: Access Forms
-
Conditional Control Source in a Form
My only problem with making one CM List table is that each program CM List autonumbers its record independently of the other CM Lists. If I was starting from scratch, I would create one overall CM List for all programs, but since the records have already begun being stored in separate tables...- PPICKENS
- Post #6
- Forum: Microsoft: Access Forms
-
Conditional Control Source in a Form
PHV, First of all, thanks for looking at my question and responding. The Iif function makes sense to me if there were only two options, but what function is used if there are multiple options to choose from. What I'm trying to say is: If [ProgramNumber]="500", then control source for the...- PPICKENS
- Post #3
- Forum: Microsoft: Access Forms
-
Conditional Control Source in a Form
I was curious if someone could help me with setting a conditional control source for a field in a form. What I mean is, I want the control source for one field to be set by my selection in another field on the form. What I'm trying to do is, When I select value "500" for field...- PPICKENS
- Thread
- Replies: 7
- Forum: Microsoft: Access Forms
