Omar

What is the control that I should use in an Access form to show the returned record from a sql database
With the ability to edit and update …
Thanks

BUD

hi, you have a lot of possibility to show the record. To edit and update, i think the best it's to add dataenvironment and put your sql query in a command. After, in your form, just to add textbox, or whatever you want, and set the datasource and datafield property to the dataenvironment and command.

i hope this will help you

Scuse me for my English

Omar

Thanks for your response ..
I want to kill myself J …. What I have now is a Stored Procedure in SQL Server 2000., this SP will Accept one parameter (the ID Number ) and will run a ( Select * from Expense Analysis) Okay …

Now the front end is MS Access , the form that I build has a text box to enter the ID Number and here I am stuck!!!!!!!! I need a to have some kind of control or a sub form that will be populated with the returned record and after being returned being able to update this record in the SQL server ..please please help
Thank

That’s what I have so far

Create Procedure Get_Rec(@ID As Integer )
As
Select * from dbo.Expense_Analysis
where ID = @ID

**********************************************

Option Compare Database

Private Sub Command4_Click()
Dim objConn As ADODB.Connection
Dim rsData As ADODB.Recordset
Dim szConnect As String

'Create the connection String
szConnect = "Provider=SQLOLEDB;Data Source =LAPTOP\SQL2000;" & _
"Initial Catalog=GL_Details;Integrated Security=SSPI"

Set objConn = New ADODB.Connection
Set rsData = New ADODB.Recordset

objConn.Open szConnect
objConn.sp_Get_Rec Text0.Value, rsData


If Not rsData.EOF Then

????????????

End If

BUD

now, if you want to show the data, the easy way is to set the text property of your textbox with the recordset.

Eg:
where name_field is a field of your procedure.
Also, if you have an textbox array, you can put it on a for.....next

Eg:
That's the easy way( but is the longuest to )
I hope this will help you

Scuse me for my English

lebb

See if this thread will help. Although his examples are geared toward using VB for a front-end instead of Access, the techniques should be pretty much the same.

Omar

Thinker..
First I am sorry for not getting to you earlier, I was busy restoring a database that crashed. And thank you for this wonderful and amazing file :-)
It really shows the essence of basic programming, I love it.
As far as the problem, I got to reach a solution but not really a good one .I have linked the Sql Table with Access and made a form. So the users can update the table .

I also tried to do the other solution. But could you please elaborate on it

Thank you

Thinker

Actually, that example was done by dcl3500. I just posted it.
I am not quite sure what you mean by the other solution?