Iam very new to access.
I have a table called MAIN
A form called frmNew_Record
A Second Table named tblRecord
In the form used to create new records, there is a field named Department. Then a second field names Recordtype. I would like the user to be able to filter the choices of the...