Is there a simple way to see if data is required for a control? (I'm still foggy on how Access relates field types, length, required and format from a table into the text/combo boxes of forms).
you can use a public function in a standard module. this air code allows you to pass any property name
Code:
Function prop(fld As DAO.Field, propName As String) As Variant
'needs error protection if propName does not exist as a property, what that is depends on how you are going to use the function
prop = fld.Properties(propName)
End Function
and called from your form with something like
Code:
if prop(Recordset(SupplierFK.ControlSource), "Required") then
'do something
end if