Bound vs. unbound controls
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I've used Access to link to the public database, built a custom table just for us, and built a form. The form uses bound controls on the left side to pull in data from the public database, and unbound controls on the right side for user entry of data.
I coded a VBA save button that should save all controls (bound/imported as well as unbound/data entry) to our local table.
The unbound controls save just fine, but the bound controls are missing from the table. A new row is created with no problems, I get no error messages, but half the fields in the table are just blank.
However each time I run it I get the message error #438, Object does not support this property or method. The 3 controls being changed consist of 2 unbound combo boxes and 1 unbound text box (they would all be bound to the same fields which is why they are currently not bound. I will update the actual table later when all the data has been entered.
I am sure I have done this before but stupidly cannot remember how.
1. reset the values for other combos on same form;
2. reset Filter and FilterOn properties for subform on same form;
3. reset Rowsource for a record locating combobox on this subform.
Currently I use combo's AfterUpdate's events for this - like:
The problem is, those events are fired whenever something on combo is selected - even when the combos value really remains same.
I want, that event will be fired only, when some combo's value was really changed, and I can't use OldValue property here, as this works only with bound controls (for unbound controls it is always same as controls current value). So I need something along lines:
Let's assume the radio buttons representing the image controls on the form are named 1-10. Let's also assume the image controls on the report are named A, B, C, D, E.
In all cases, image control A on the report will contain image 1 and image control B will contain image 2. For C, D and E they would display the remaining selected images from the form. How these images are ordered is not important.
How can I dynamically assign the remaining selected images to image controls C, D and E on the report?
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.
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
I would like the form to open unlocked by default (or at least apply no locks on a newly created form), so that the user can manually lock all the controls, bound or unbound, with a click on a command button, after he's finished. Maybe it's not kosher with Access, but I'd prefer to avoid heavy programming in VBA...
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.
I cannot for the life of me get my DELETE button to refresh my bound controls after I click the delete button and delete a row. The deleted row is still in my controls until I exit from the form and reenter.
I have tried clearing the data set, re-filling, etc. I cannot get anything to work.