|
||||||
|
Association 4 By Richard Rost 22 months ago Microsoft Access Association Database, Part 4 This is Part 4 of my Microsoft Access Association Database. We will convert the old customer form over to the new person form and add whatever fields we have to. We'll learn how to make Control Tip Text and use the Locked property. We will add a family combo box to select which family this person belongs to. We will create a family form with a combo box to select the head person of that family. We'll modify the row source of the combo box to only show people in that family. This will involve changing the SQL statement and using an OnCurrent event in the form. Pre-Requisites
Links
MembersWhat's Next
Keywordsaccess 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Person Form, Control Tip Text, Locked, Family Combo, Family Form, Head of Family Combo, OnCurrent Event, Change SQL RowSource
|
||||||||||||||||||||||||||||||||
| |||
Keywords: FastTips Access Fast Tips Person Form, Control Tip Text, Locked, Family Combo, Family Form, Head of Family Combo, OnCurrent Event, Change SQL RowSource head of household PermaLink Microsoft Access Association Database, Part 4 |