accessing records of a table

F

Farooq Sheri

I have a table Tab1 (imported from a excel sheet; a link table). I want to go
to a particular record in the table based on the value given in a textbox
Text1 and read in value from certain fields into textboxes Text2 & Text3.
After this I want to move to the next record and read some more values. For
your reference the table looks something like this (This is actually one
record but is arranged as below)

SDL NAME INEQNTYPE INEQN OUTEQNTYPE OUTEQN
"RIN1MCT" LTG SET 7 LTG SET
2
LTG ID 58 LTG ID
36
DIU ID 0 DIU ID
0
STM CHN 15 STM
1

For example I want to search record with SDL = RIN1MCT and read in INEQN &
OUTEQN values. Next I want to move to the next record (here the next line in
table) and read in INEQN and OUTEQN values once again.

Thanks
 
J

Jeff C

I think you should try viewing your table by filtering, while the example
from your table didn't make much sense to me, if I have a text field with
certain values I want to read I can filer by that value in the field (using
advanced filters) Maybe that helps you?
 
F

Farooq Sheri

The example from the table is not making any sense because it lost its
aligment after I had posted my question. There is only one value under
DATALINK (RIN1MCT" ) while INEQNTYPE has the following four values in
consecutive lines (LTG SET, LTG ID, DIU ID, STM CHN). Similarly for INEQN the
4 values (7, 58, 0, 15), OUTEQN (LTG SET, LTG ID, DIU ID, STM CHN), and
OUTEQN (2, 36, 0, 1). This actually constitutes one record but is spread over
4 lines. The value which is known is DATALINK value (in Text1). Based on this
I want to read in the 4 values of INEQN and the 4 values fof OUTEQN. Perhaps
this explains my problem better. I think filtering would not help or perhaps
you can show me how it will work.

Thanks
 
Top