I am spinning my wheels here. I have created a form called Add New IA which saves to the IA__tbl. There are 4 fields for the user to populate.
1. IA Number - I have been able to code the IA Number so user is required to enter 6 digits.
2. IA Name - no issue at this time
3. IA State - I would like to use a list box here but can't get the setup right. Is my relationship setup incorrect? State_tbl linked to IA_tbl
4. Ticket Type - list box like IA State
When saving record would like to validate that all 4 fields are populated. My code does ask user if they want to save - thats ok but would really like to double check that all fields are populated.
DB is attached. Thanks.