refering to fields in VBA

[carlee]

Hi there,

I am working with some VBA code. I want to refer to the
ShipmentNumber (number), varietyNumber (number) and
PropagationNumber (text) fields of table 'tblLabel'.

What i want to do is take the values of these fields and
put them to a .txt file. How can I do this?

Many thanks in advance,

Carlee

 

[Ken Snell]

You would need to open a recordset based on the table tblLabel, loop through
each record, and write the value from those fields for each record into a
text file that you have opened in code. Post back if you need more details.