Bound vs. unbound controls
Thank you for taking the time to report an issue.
What's wrong... Please write below.
If anyone could provide some information on a possible solution, or some better definition on the event order when the form's navigation buttons are clicked, I would be greatful. I am using Access
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.
When the custom print preview button is clicked, the data from the unbound controls do not appear in the preview. But if I use the file-print preview menu item, the data is properly seen.
Below is the code written in the button click to display print preview
DoCmd.SelectObject acForm, "AnswerForm"
Printer.Orientation = acPRORLandscape
I am unable to figure out why this behavior is happening. Any help with this is appreciated a lot.
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:
What I am getting is the bound controls populated with the data from the oldest record, lowest autonumber, in the linked table. Very unprofessional effect to always have the same person's data show up whenever the form is opened
**The field in question is in its own table because it is a memo field that gets changed regularly in production. The production environment has this as a bound control but I am trying to implement unbound controls to avoid excessive record locking.**
Is there some limit on text controls regarding length of text? I cannot find anything by googling or searching this forum