Date picker is not availble or editable

shafara7

Registered User.
Local time
Today, 19:30
Joined
May 8, 2017
Messages
118
I have two forms, both have a subform on it and shares some identical fields in the subform.
I am able to change the date in the field txtPruefbericht and txtDurchsprache on the subform of Form 1 using date-picker and self-type.
But for Form 2, I can't change the date. It's unclickable as if it is deactivated.
It's weird because both of the field are the same.

I have checked whether it has an Input Mask but nope.
I also checked whether it is Enabled and Locked and it is enabled and unlock.
The Show Date Picker is also selected.
Also, when the textbox is set to lock, the background appears red and when I unlocked it, it turns white or grayish. You can see it in the phote of Form 2, where I set the Pruefbericht to activated and unlock and for Durchsprache I set it to activated and locked.

Is there anything I need to check to make the date picker available?
Could there be something that deactivate the edit function?
 

Attachments

  • Form 1.png
    Form 1.png
    40 KB · Views: 131
  • Form 2.png
    Form 2.png
    23.5 KB · Views: 121
I suggest checking the underlying record source query of the form to see if it is editable. There are a variety of things that will make a query uneditable.
 
Okay but what should I be looking for at the record source query?
 
I have two forms, both have a subform on it and shares some identical fields in the subform.

It sounds like both Subforms are based on at least one Field from a single Table...is that so?

Are both of these Form/Subforms open at the same time when the problem occurs?

Linq ;0)>
 
Just run the query and see if you can edit the field that you are having problems with.

Seems like I can't edit the field in the query. Is there anyway to activate it?


It sounds like both Subforms are based on at least one Field from a single Table...is that so?

Are both of these Form/Subforms open at the same time when the problem occurs?

Yes, the field that I have problem with from both subforms are based on the same table.
And no, it's not open at the same time.

It's weird because the first form is editable but the second is not.
I think the person who create this form do this on purpose and I just need to find out how to activate it. Please share if you have any idea :)
 

Users who are viewing this thread

Back
Top Bottom