>Hello Everybody,
>
>I got some problems to program VB with Acess, cause i need to show my request (from 2 tables) in a DBlist. But to do that i use a inputbox to "Take from the user his accountnumber", after that i have to put this accountNumber in my request and show the final result in my DBlist.
>
>Here's my Tables in Access
>
>Table : Clients
>---------------------------
>AccountNumber (Primary key)
>FirstName
>LastName
>AdressNumber
>Street
>PostalCode
>Province
>PhoneNumber
>
>Table : PhoneCall
>----------------------------
>AccountNumber (PK)
>CallNumber (PK) (autoNumber)
>DateCall
>HourCall
>TownOwn
>TownCalling
>CallTimeLapse
>
>So i need to know how to put the Inputbox in my request
>
>Thank you very much for your time, you are a kind of god !!!!
>
>
>Ps.: If you Speak french, pouvez-vous me répondre en français SVP, ca me faciliterais la tâche de beaucoup Merci.
>
>Dominic Sicotte

Dim strSQL as String
Dim strUI as String

strUI = InputBox("Enter you Account Number / Entrez votre numéro de compte")
If Len(strUI) > 0 Then
strSQL = "SELECT * FROM Clients, PhoneCall " & _
"Where Clients.AccountNumber = PhoneCall.AccountNumber " & _
"AND Clients.AccountNumber = " & Val(strUI)
End If

Try this / Essaie-ca!