After Update in Subform

[Jill]

There is probably a very easy way to solve this problem, but unfortunately I can't figure it out. Hoping someone can help.........please!

I have a listing database which tracks all of our properties. I need to start tracking what services have been done on these properties, so I added a new vendor table and new vendor form. Then I linked this form as a subform within the main property form based on File #. So I open the main form for 123 South Street and in the subform I can see all of the services that have been performed and by what vendor. What is giving me problems is within the vendor form, I set up a macro to set values for address, city, state, zip, phone # based on the combo box of vendor name. (i.e. the user selects the vendor name and all contact information is automatically filled in). This works great if the vendor form is opened separately, but when I put it in the main form as a subform and select the vendor name I get these errors saying it can't find my vendor form.

Any suggestions would be greatly appreciated on this one!

Thank you!
Jill

 

[Rob.Mills]

You need to change the syntax when you make a form a subform. So for instance let's say you have a control on a form named ID. To refer to it as a form you would type:

Forms!FormName!ID

or

Me!ID

Once you make it a subform you need to change everything to:

Forms!MainFormName!SubFormName.Form!ID

 

[Jill]

Thanks Rob! This worked great. I appreciate the help!