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
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