accessing record with VBA

[macroapa]

Hi,

I have a table (linked table to another access db).

The table has 3 fields:

Date Qty1 Qty2

I'd like to be able to display in a msgbox the value of a field from a
record but am really struggling to do it. How can I access the data
(and subsequently update it via VBA)?

Thanks for any pointers.

 

[Allen Browne]

You will need to learn about recordsets to manipulate the data directly in
VBA.

Here's the basic code to open a recordset and loop through the records:
http://allenbrowne.com/func-DAO.html#DAORecordsetExample

BTW, DATE is a reserved word, so will cause you problems if you have a field
with that name.