Accessing and updating data in unopened tables

[klfduncan]

Hi all,

What is the correct syntax for accessing data in an unopened table?

E.g. I have open a form bound to the table 'Customer'. It has a field called 'orders' in which I put the number 'x'. I want to create 'x' new records in the table 'CustomerOrders'. The two tables are linked by the referenced number 'RefNum'

Any help, as ever, very gratefully appreciated.

Thanks,

Keith

 

[PHV]

You may consider DoCmd.RunSQL "INSERT INTO ..." inside a loop.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[BNPMike]

Why don't you have the orders on a subform? Then you don't need to insert them. Access does this automatically for you.