Problem: I am having an issue getting the unbound boxes to populate the product_id and change_id field in the actual table when I try and save. I am really at a loss. Have been googling calculated fields and before update for the last couple of hours...
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Haven't looked into this too much as I'm pretty novice to the development side of forms and such. Someone mentioned unbound in one of my questions and I just saw a tutorial about creating splash screen and it mentions you should create an unbound form
Both forms have a textbox called Date, which are identical except for one is Unbound and one is bound to the Date field from a table.
The Datepicker only appears on the Unbound textbox - if I unbind the textbox on the viewing form, it reappears.
Why is this? Is there any way of getting a datepicker to appear on a bound text box, or would I have to use a custom calendar control?
However, I also have unbound fields on the form. Once I change an unbound field, this appears to mess up the UnDo logic as from that point, changing a bound field no longer causes the Undo button to become active.
Ideally, I'd like the UnDo button to work with both bound and unbound fields but at least I'd like to prevent the unbound fields from messing up the UnDo for the bound fields.
Played with padding in Properties. Is there a property that keeps those fields together? Looking for a way of "undoing" formatting, inserting new fields, shifting the fields around, and then reinstating WITH the newly inserted unbound field.
Let's say in field name: Doc_Name when I click a record from this field, access will filter related date in the 2nd subforms.
My problem is that I cannot seem to get the mouse to focus on the unbound text boxes on this split form. when I click in the unbound filter by form text box, the focus immediately moves to the first text box that is bound to data on the form.
Then I will try recreating my split form in a different way. if it is a problem, If perhaps a split form cannot have any unbound data entry controls on it, then I could create a form with the search criteria on, and keep the forms separate. If I was to do this, though I would like to 'dock' this form at the top of the window, and then have the split form 'dock' underneath, as if there was an application level window splitter control. Another option might be to put the filter by form text boxes in the ribbon, and I have added some stuff here, but I am unsure how I might refer to the control in a query criteria.
e.g., insert value in subform.pos_sts into an UNbound control on MainForm.
Of course the value in the subform control changes as you scroll through records so the value in the UNbound Control on Main/Parent form should change accordingly. I have tried something like =[forms]![SubformNm]![ControlName] in the UNbound control on the Main Form .but was getting #Name error?