Unable to view a subset of data in a combo box

BradyL

New member
Local time
Today, 17:13
Joined
Jun 5, 2002
Messages
9
I am stuck, please help! I have limited access experience so please explain with that in mind.

my setup:

In my main table there is a column called versionID which links to another table where versionID and versionName are the columns. My main form has a combo box which is supposed to display the versionName of the current record. The row source of the combobox is a query to display all the versionNames.

the problem:

When I first open the form the versionName combo box apears to be blank for a subset of versionIDs and is displayed correctly for the complement of that subset.

notes on problem:

-If I run a requery on the combobox I can then view all the data properly.
-If I change the form to view the versionID rather than versionName I can view the versionID without any problems.
-If I add an onEnter command to the combo box to requery I can THEN view what the versionName is, but it appears blank until clicking on the box.

my thoughs on solution:

A solution may be to run a requery on the combobox when the form opens, but I tried this in the open, activate, and load events for the form. Also,I have this problem with other combo boxes on this form.

Any help would be greatly appreciated. Much thanks in advance.

BR,

Brady
 
I think your combobox might be bound to the wrong field. Delete the combobox and re-add it using the wizard. Choose the option to hide the key.
 
Jon and others,

Thanks for the reply. At first I didn't think your solution would work, but I then encountered something else in trying to add a new combo box....

When given the option to select the data for the combobox, versionID is listed as available but versionName is not. The current database is connected to a postgresql server. However when playing with old copies of the database where the data is stored locally in access, the versionName is available. I'm not 100% sure, but pretty close to it, that the problem lies within access and not the server. Again, thanks in advance.

BR,

Brady
 

Users who are viewing this thread

Back
Top Bottom