I have a form that runs a report to pull info. (Not sure if this is even the correct subforum to put this on)
And what this query is supposed to do pull info from combo box based on the start and ending numbers of orders for customers, but what I want to do is default the ending number to be what the starting number was as soon as the starting number is entered, but allow the user to change that if they want. I just want to make sure that it has a value. I tried to set the field to required, but that doesn't seem to be doing the trick. Any ideas?
And what this query is supposed to do pull info from combo box based on the start and ending numbers of orders for customers, but what I want to do is default the ending number to be what the starting number was as soon as the starting number is entered, but allow the user to change that if they want. I just want to make sure that it has a value. I tried to set the field to required, but that doesn't seem to be doing the trick. Any ideas?