I am using Access 2000.
My main form has a record source of a table (employeeTbl with key of
[EmployeeID]. It is filtering the record results.
My subform and mainform have the link child/link master set to
[EmployeeID] and the source object is the subform.
My subform record source is a query from another table (vacationTbl).
FYI: I was filtering on the subform, but removed it and replaced with
query because of a bug pointed out by Allen Browne "FilterOn not
set/removed correctly for form and subform combination" at
http://members.iinet.net.au/~allenbrowne/bug-02.html
I populate a combobox on the subform for each subform record. I use
the 'On Enter' event to do this. I also set the value using
'Me.cboMyTest.Value = MyTestValue' inside the On Enter event. I do not
have a default value set for the cboMyTest combobox property, as it is
populated by a function.
Funny thing is, when the form displays, the comboboxs for each of the
records on the subform doen't have a selected value in them.
When I finally click on a combobox, all of a sudden ALL of the
comboboxes show the first selected value. I would expect for this
value to be selected when the form opens, not after I click on one
combobox.
It is strange, because I deleted the whole subform from the main form,
and then added it back, and the problem went away. But it showed up
again sometime later.
Another strange thing that I have observed is that when the main form
opens, sometimes some of the comboboxes have a value set, and some
don't. Again, deleting the subform and re-adding fixed for awhile.
When I open the subform by itself (without the mainform) all comboboxes
are populated, as I would expect.
What is going on? Am I doing something wrong? If it is access
problem, is there a work around.
Thanks in advance for your help.
Cy