For entry for a tabbed subform that is based off of 2 tables and a lookup table, would it be better to create the form based off a query?
I have code behind the form because one table will only be filled out if it meets certain criteria based on the main form but it keeps erroring because if the lookup info is not filled out then it will not keep the entry in the form.
Please help!!! I have been working on this portion of the database for several weeks now and have yet to really make any progress and I am coming up against a deadline. I have 2 other posts here in the forms that several have helped on that have gotten me closer to where I need to be but I'm hoping this is the last stumbling block. I have gone back and fixed the tables so they are more normalized.
I have one table that will always be filled out and then the other table will be filled out if a field in the main form has "active" in the combo box and the third table is a look up table connected to the table that will only be filled out if the "active" status is met.
Am I doing something wrong in the set up as far as having a table that may or may not be filled out based on the main form?
I have code behind the form because one table will only be filled out if it meets certain criteria based on the main form but it keeps erroring because if the lookup info is not filled out then it will not keep the entry in the form.
Please help!!! I have been working on this portion of the database for several weeks now and have yet to really make any progress and I am coming up against a deadline. I have 2 other posts here in the forms that several have helped on that have gotten me closer to where I need to be but I'm hoping this is the last stumbling block. I have gone back and fixed the tables so they are more normalized.
I have one table that will always be filled out and then the other table will be filled out if a field in the main form has "active" in the combo box and the third table is a look up table connected to the table that will only be filled out if the "active" status is met.
Am I doing something wrong in the set up as far as having a table that may or may not be filled out based on the main form?
