These may be more complicated questions than I think but I thought I would ask.
Is it better to leave the table properties alone and use code to set the properties like "Allow Value List Edits or Show only Row Source Values" or set them in the actual table?
Is it best to use a SELECT qry for the cbo Row Source in the table Lookup properties [example: SELECT tbl_TestEquipment.TestEquipmentType FROM tbl_TestEquipment GROUP BY TestEquipmentType;] or is there a better way to do this. I think this one is the way to not use lookup fields. Please correct me if I am wrong. I am trying to understand commandment number 2 of the 10 access commandments.
Thank you for your time and knowledge,
Walker