how to use recordset

A

alejandro

What i m doing wrong in this code i want to load a form qirh a recordset but
something is wrong

Private Sub Form_Open(Cancel As Integer)

Dim rsf As Recordset
Dim ssql As String
ssql = "select * from product where code=1 "
rsf.Open
Set rsf = ssql
Form_individual.Recordset = rsf
rsf.Close
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

load a recordset 1
What is bad in this 2
how to code a button to export results of stored procedure to excel file 0
Recordset in Access 2007 1
recordset 2
modify code to just insert Mon-Sat date and day for Given Week End 0
Dim rs As DAO.Recordset Error 1
INSERT INTO not inserting anything into anything :-( ! 1

Top