By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,963 Members | 1,815 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,963 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.