A little help please

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

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