468,243 Members | 1,925 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,243 developers. It's quick & easy.

ComboBoxes on Subform don't display value until one is clicked.

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

Nov 13 '05 #1
0 1706

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Tim Graichen | last post: by
6 posts views Thread by Sally | last post: by
5 posts views Thread by Thelma Lubkin | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.