Access 2003 Combo Box/Recordset Issue

  • Thread starter Thread starter Spratty
  • Start date Start date
S

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 said:
What is the code behind the button
Click to expand...

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