A little help please

[egiggey]

I have an access db with 4 field PK, Url, name of site adn file extension
now my problem comes that I want the user to be able to choose the site name(in a combo box) and when the user clicks the name have the app populate two textboxs one with the url and the other with the file extension
any Ideas

[Gaffer]

you need to use recordsets, something like:

(access97 using DAO)
Sub cboYourCombo_AfterUpdate()

Dim sSearch as string
dim db as database
dim rs as recordset

set db = Currentdb

sSearch = cboYourCombo.Text

set rs = db.openrecordset("select * from tblYourTable where YourField='" & sSearch & "')

rs.movefirst

txtFirstTextbox = rs("FirstField")
txtSecondTextBox = rs("SecondField")

rs.close

End sub