I have combobox whose rowsource type is set to Table/Query. Its rowsource is set to a query that displays five columns. The columns are sorted by first then second then third. The BOUND column property to the combobox is set to column five.

In VBA code, I am able to choose a value from the combobox and set the record of the form to match the value based on that fifth column value in the combobox list.

    Dim rs As Object

    Set rs = Me.Recordset.Clone
    rs.FindFirst "[strApp] = '" & Me.cboApp & "'"
    If Not rs.EOF Then Me.Bookmark = rs.Bookmark

    Set rs = Nothing

This works. The catch? Well, after the combobox closes, it displays the value of the first column for that row, not the fifth.

I've checked the query, the bound column setting (5), the column width properties (0.5";1.5";0.25";4";1.5") and the column count property (5). Still, even though the bound column is no. 5 and the combobox's AfterUpdate event is working correctly, it still shows the FIRST column's value instead of the fifth in the combobox. I must be missing something obvious from staring at this too much.

Any clues?


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division

Greg,
Do you store any of the 5 values anywhere after the fact?

Kevin


dartcoach

I had a similar problem with a list box. The problem was solved during the
wizard fase when the list box was beeing created. When asked where the value would have to be stored i answered that the PK would be the place. When closing the form i had some errors messages telling that the value couldn't be saved. I have silenced the errors messages and everything worked as expected. If there is a more technical solution to the problem i would like to know.
rgds Penta

Kevin, no the values are not stored anywhere. The combobox is UNbound. The combobox is used merely as a look-up to make the chosen permit number off the list move the record pointer to that choice. When I created the combobox with the wizard, I chose "use that value later" or something like that.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

I was just informed by someone in another forum about what's going on. Check this out...

http://www.utteraccess.com/forums/sh...&Number=739590


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division