Access 2003 Combo Box/Recordset Issue

[Spratty]

Hi all.

I have a problem with an Access 2003 project I'm modifying. There is a combo
box which is bound to a SELECT statement returning three fields. When the
user has selected an option and pressed a button to proceed, the code behind
the button click makes a copy of the combo box's recordset and extracts the
second column which is the data required. The first time the user drops down
the combo box, no matter which row they select, the data returned by the
recordset is always for the first row. Any subsequent selections return the
correct data - it's only and always the first selection which fails.

Can anyone suggest a way to get round this or get it working correctly?

Thanks in advance,

Tony.

 

[wisepin]

What is the code behind the button

 

[Spratty]

What is the code behind the button

The code in question is as follows:

------------------------------
Dim rs1
Dim str_DocumentMaster As String
Dim str_filename As String
'Dim Str_Datafilename As String

rs1 = Doc_Format.Recordset
str_filename = rs1.Item(2).Value
Set rs1 = Nothing