Computer Learning Zone CLZ Access Excel Word Windows

If it ain't broke, don't fix it.

-280th Rule of Acquisition
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
Home > Courses > Access > Templates > ABCD > Part 1 < ABCD | Part 2 >
ABCD Core Part 1

Back to ABCD Core Part 1

Core 1 Lesson 9 Person Code Upload Images   Link  
Ron VandeVelde 
7 months ago
The current project I am working on only has 2 possible Organizations in it. I would like to design the code for the Entity Code creation to start with something other than P, I would like the value assigned to depend on which Organization is selected. For example, if I have Organization A and Organization B as the possible Organizations. If you create an Entity with Organization A, the Entity Code would be "OA" + the numbers, if you select Organization B, the Entity Code would be "OB" + the numbers. Can you help me with the IF statement to accomplish that, and where I would need to put it so that it runs AFTER the Organization is selected? Or would that part be easier to just move the the Organization to be the first thing on the Entity Form?
Ron VandeVelde
7 months ago
I just realized an issue with the way I was doing this. I had OrganizationID with a list of the Organization's in the HelperTypeT/HelperT. This was causing me an issue with the Address form with the TempAddress. So if somebody knows what I would need to do to make everything work with my current set up I will just change it to have them have to type in the Organization Name for each entity in a text box.

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to ABCD Core Part 1

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn