Is this correct?

A

AndreMello

Hello everybody
I have this code in my project

Dim rec As Recordset
rec.OpenRecordset ("select TPOFTO,CLSFTO from [Processos Urgentes]")
If (Me.CombClasseProcesso.Column(0) = rec.GetRows(0)) Then
If (Me.CombTipoProcesso.Column(0) = rec.GetRows(1)) Then
MsgBox "Whatever", vbExclamation


Well, it probably isn't correct because i'm getting an error.
I am kind of new to Access Sintax so could someone help me out on wha
do I use to get the information from tables in my database an
comparing them with items in my form?
By the way, I'm using Access 97 :(
Thank
 
R

Rod Scoullar

Dim rec As Recordset

Set rec = CurrentDb.OpenRecordset ("select TPOFTO,CLSFTO from [Processos
Urgentes]")
If Not rec.EOF Then
If Me.CombClasseProcesso.Column(0) = rec!CSLFTO Then
If (Me.CombTipoProcesso.Column(0) = rec!TPOFTO
...
End If

Rod Scoullar
 

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

You must use the dbSeeChanges option with Open Recordset whenaccessing a SQL Server table that has a 1
Acc 2007 Subform Recordset vs Acc 2002 Subform Recordset 2
Can't cancel an automatic Access message 6
building an array for a listbox 2
Using ADO recordset as combo box row source gives "id is invalid" 1
can't find the right query 0
Requery error when using a MS Access 2k designed db app with 2k3 & 0
Can't stop system error 4

Top