Recent content by RobMls

Thanks jdraw, but I'm afraid that is not what I am looking for. I can create linked subforms, no problem. The problem is the subform's combobox, I only want it to display brands that are linked to the client. It is more user friendly with them.

Hi everyone, I still have not been able to solve this problem. Any help much appreciated, thanks!

I have attached a copy of the database (converted from 2007 to reduce file size). Hopefully this will help. Thanks!

I have tried: Forms!ClientForm!BrandForm.Form.Brand_Name BrandForm.Form.Brand_Name BrandForm.Brand_Name BrandForm.[Brand Name] Where: ClientForm = the main form BrandForm = the subform Brand_Name = the data field All throw up error saying that the item does not exist?

Hi, Thanks for your reply. What goes in the 'NameOfControl' bit? I added the field name, it is two words, is that why I get an error?

Hi all, I have a a form 'clientForm' based on a database called 'clientDB'. In this 'clientForm', I have a subform, that lists all the 'brands' related to the 'client' record being displayed (linked by a one to many relationship). brandDB.Client ID (foreign key) many - clientDB.Client ID...