Am trying to create a relationship between two tables in VBA using:
Dim rel As Relation
Set rel = db.CreateRelation("AtoB", "[Data Conversion].Primary", "[Data Word Table].[Primary Key]")
Ive tried several varients, but cannot get it to work. At the moment when i run it, it comes up with:
Run-time error '424':
Object required
I'm completely stumped by this, I can't even find what a error 424 is let alone how to fix it!
Again, any help is greatly appreciated!
Dim rel As Relation
Set rel = db.CreateRelation("AtoB", "[Data Conversion].Primary", "[Data Word Table].[Primary Key]")
Ive tried several varients, but cannot get it to work. At the moment when i run it, it comes up with:
Run-time error '424':
Object required
I'm completely stumped by this, I can't even find what a error 424 is let alone how to fix it!
Again, any help is greatly appreciated!