472,807 Members | 3,571 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,807 software developers and data experts.

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

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

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.

Nov 13 '05 #1
0 1866

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: deko | last post by:
I have two subforms within a particular form. The one on top is a datasheet of transactions; the one on the bottom is a summary of totals. I would like to have the datasheet fill the entire...
by: Carl | last post by:
I have a main form with navigation buttons on it and a label showing for example Record 1 of 15 using recordsetclone on it and eveything works fine. When I move through the records the record...
by: Lyn | last post by:
Hi, I am working on a genealogy form. The only table (so far) lists everybody in the family, one record per person. Each record has an autonum ID. The parent form (frmMainForm) displays the...
by: Tim Graichen | last post by:
I have FrmMain that has one subform (SbForm). FrmMain is filled with records from Tbl1. SbForm is filled with records from Tbl2 based on the current selected record in FrmMain from Tbl1. ...
by: Sally | last post by:
I need to be able to click in a subform and run code but at the same time I need to be able to scroll the records without running the code. I tried coding the Enter event of the subform control but...
by: tdmailbox | last post by:
I have a form with a child form. In the child form there is a list of names that can grow quite large. On the parent form I want to display the first name from the child form. I set up a test...
by: sasan3 | last post by:
I have a main form "topform" contaning "subform1" and "subform2" The goal is: I need to requery subform2 on CURRENT event of subform1, and I need to load subform2 contents based on settings on...
by: Thelma Lubkin | last post by:
I have a form/subform with the common one-to-many relationship. The form allows user to display records and move to other records via the selector, to add,delete, and edit them, with the related...
by: fenners | last post by:
Hi new to programming VBA in Access 2003. I have a form which has two comboboxes. The first combobox uses the folowing rowsource. SELECT Outputs_Classification.Output_id,...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
by: lllomh | last post by:
How does React native implement an English player?
by: Mushico | last post by:
How to calculate date of retirement from date of birth
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.