Value lookup by record number

  • Thread starter Thread starter Gurtz
  • Start date Start date
G

Gurtz

Hi Andy,

I don't quite understand what you are trying to do.. are
you trying to query the database for a specific field and
store it in your form (perhaps in a textbox)? Post back
with a better description of your problem and someone will
respond.
:)
Gurtz
[email = no $]
 
Thanks for the help Gurtz,
I've got a set of about 1400 records. Using the
recordsource of the form, I add something like:
WHERE ((([Operation ID Listing].Operation)='Planting'));
Now, I'm down to about 100 records. Only those Planting
records are shown- and this part works great.

Now, I'd like to figure out which Farming Plots were
Planted. I have records 1 - 100, and I'd like to be able
to extract these values and store them in an array with
100 elements. I know how to deal with arrays, but I don't
know how to pull out those Plot numbers.

DLookup doesn't seem to be the answer right now, because
I can't increment by records. I'd like to be able to say
Give me the value in the Plot field for record 1, then 2,
then 3... etc.

I hope this is clearer- any ideas?
-----Original Message-----
Hi Andy,

I don't quite understand what you are trying to do.. are
you trying to query the database for a specific field and
store it in your form (perhaps in a textbox)? Post back
with a better description of your problem and someone will
respond.
:)
Gurtz
[email = no $]
-----Original Message-----
Hello all,
I am trying to do something pretty simple. I've got a
form with a recordsource with an SQL WHERE in it.
I want to be able to take the value of a field in record
number 5 and store it in a variable. i just don't know
the command for this.
DLookup isn't it- it will find records that match a
criteria. This isn't what I want. I'd like a specific
record.

If anyone has any ideas, I'd be happy to hear them,
Thanks,
Andy
Click to expand...
Click to expand...
 
Andy

Elwin's post will do what you originally asked for. Having read your
response to Gurtz you need to use a variation on Elwin's post;

Dim rst As DAO.Recordset
Dim intI As Integer
Set rst = Me.RecordsetClone
With rst
.MoveLast
.MoveFirst
For intI = 1 To .RecordCount
arrPlots(intI -1) = ![Plot Field]
.MoveNext
Next intI
End With
rst.Close
Set rst = Nothing

HTH

Andy

Andy Korth said:
Thanks for the help Gurtz,
I've got a set of about 1400 records. Using the
recordsource of the form, I add something like:
WHERE ((([Operation ID Listing].Operation)='Planting'));
Now, I'm down to about 100 records. Only those Planting
records are shown- and this part works great.

Now, I'd like to figure out which Farming Plots were
Planted. I have records 1 - 100, and I'd like to be able
to extract these values and store them in an array with
100 elements. I know how to deal with arrays, but I don't
know how to pull out those Plot numbers.

DLookup doesn't seem to be the answer right now, because
I can't increment by records. I'd like to be able to say
Give me the value in the Plot field for record 1, then 2,
then 3... etc.

I hope this is clearer- any ideas?
-----Original Message-----
Hi Andy,

I don't quite understand what you are trying to do.. are
you trying to query the database for a specific field and
store it in your form (perhaps in a textbox)? Post back
with a better description of your problem and someone will
respond.
:)
Gurtz
[email = no $]
-----Original Message-----
Hello all,
I am trying to do something pretty simple. I've got a
form with a recordsource with an SQL WHERE in it.
I want to be able to take the value of a field in record
number 5 and store it in a variable. i just don't know
the command for this.
DLookup isn't it- it will find records that match a
criteria. This isn't what I want. I'd like a specific
record.

If anyone has any ideas, I'd be happy to hear them,
Thanks,
Andy
Click to expand...
Click to expand...
Click to expand...
 
Back
Top