VBA Error When Adjusting Master/Child fields

[kdbailey]

On a form I have two listboxes and a subform that is continuous.



The two listboxes are "Products" and "Code Sets". The idea is that you select a product and a code set and it will show you the codes associated. The list is filtered by a link master/child to the two fields.

I am trying to make it that when you only have a Product specified, it will show you all codes from all sets. When I go from two linkfields to one, it gives me run-time error '2335'. You must specify the same number of fields when you set the LinkChildFields and LinkMasterFields properties. Can anybody explain why I'm getting this error?

Just going from

Me.sublist.LinkMasterFields = "Product,Code Set"
Me.sublist.LinkChildFields = "Product,Code Set"

to...

Me.sublist.LinkMasterFields = "Product"
Me.sublist.LinkChildFields = "Product"

[kdbailey]

Update:

Ignoring the error makes it run perfectly fine, but I still want to know why it throws an error in the first place.

[Bulzie]

Where are you running the 2nd one, on the after update of Product listbox? Also maybe try full path Forms![frmMain]![sublist].LinkMasterFields = "Product" instead of "Me."?

[kdbailey]

Yes, the after update.

The main form is actually using a record source from a table that holds the value of the User, Product and Set. The product listbox control source is field "Product", code set listbox control source "Code Set". I don't think this is the issue. It seems like it wants me to adjust both Master and Child links at the same time.

[kdbailey]

Misread what you were saying, I tried the actual path of "Me." and the same error occurs.

[Bulzie]

I think it is giving error as when you change first LinkMaster, they then are different number of arguments and gives error. Try to set both to "", then change both to "Product"?

Me.sublist.LinkMasterFields = ""
Me.sublist.LinkChildFields = ""

Me.sublist.LinkMasterFields = "Product"
Me.sublist.LinkChildFields = "Product"

You might still need to use the full path to subform and not "Me."

[kdbailey]

It is referring to "Me.sublist" which is the name of the subform.

It indeed works by adjusting to empty values first. That's really odd that it forces you to completely remove the links.

[CJ_London]

not sure if it relevant but your initial example

Me.sublist.LinkMasterFields = "Product,Code Set"

Code Set as a space, so you need to use square brackets

Me.sublist.LinkMasterFields = "Product,[Code Set]"

[kdbailey]

not sure if it relevant but your initial example

Me.sublist.LinkMasterFields = "Product,Code Set"

Code Set as a space, so you need to use square brackets

Me.sublist.LinkMasterFields = "Product,[Code Set]"

It works fine without brackets.