Views: 9 Size: 763.0 KB">NewDBTest-davegri-v02.zip
Changed main form so that it looks up the correct city.
Excess Access
Windows 10 
Access 2016
Views: 9 Size: 763.0 KB">NewDBTest-davegri-v02.zip
Changed main form so that it looks up the correct city.
Novice
Windows 10 Access 2016
June - Yes, each UZA can have multiple apportionments. The "code" was initially meant to be another institutional identifier for an UZA - it hasn't really been setup yet.
Mike - That's it!! What in the world was I missing here? I can see that there are now dropdowns in Tbl_UZA (+)? Other than that, the form looks pretty darn close to what I had. I'm still learning so any explanation on what I was doing wrong would be great. Thanks, again!
VIP
Windows 10 Access 2010 32bit
What was missing is described in post #14.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
VIP
Windows 10 Access 2016
Hi
What you have is a standard Main Form / Subform setup
Main Form based on Main Table
Subform based on Related table
Linked using UZAID
Added a Combobox in the Header of the Form to look for a specific Record.
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
Consisntent and inconsistent data type in subform
Limited number of entries in a subform with data validation
Posting Permissions
Reply With Quote