I have a form set up with a subform, when I enter a contract number into a text box the form ReQueries and shows contract specific data in subform (the subform shows relevant items with blank volume fields). A month is entered into another text box on the main form, then data is entered in the subform number fields, and finally there is a button that writes the records to the database.
Problem: Data is loaded monthly, ideally I need some means of testing whether the month and contract already exist in the table, if they don't then the above subform is OK, however if they do I would like a different subform loaded.
How can I accomplish this?
Problem: Data is loaded monthly, ideally I need some means of testing whether the month and contract already exist in the table, if they don't then the above subform is OK, however if they do I would like a different subform loaded.
How can I accomplish this?