I have a combobox in a form tied to a table field. The table field is not configured to be required. But the form requires this field to be entered or else it won't process the record. Any ideas how I can fix this? Thanks.
I have a combobox in a form tied to a table field. The table field is not configured to be required. But the form requires this field to be entered or else it won't process the record. Any ideas how I can fix this? Thanks.
There is probably code behind the form that is enforcing the requirement if the restraint is not coming from the table. Look at the Update events for the form and the control, or post a zipped db copy.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
There is no code behind the form that I entered. I am not sure why this is happening. I have a form of workorders that contains a subform indicating the different parts (skus) needed for the particular workorder. Each sku part requires an approval code, but only some parts require an approval explanation. But the form is acting as if the approval explanation field is required for every record. Could it be something with my relationships?
Sure it could be a number of things, but we know nothing of the application.
Can you post a copy of the database with enough info to highlight the issue?
Did you create the database/application?
What is the nature of 'acting as if the approval explanation field is required' - error message?
Is there anything in ValidationRule property?
To provide your db for analysis, follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
If this is on a subform then yes, it could be a relationship thing if you're trying to move off of the subform record. The exact wording of the message would help as June7 wrote. Or post a zipped db cop.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.