Help with an Error ??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was trying to set the "link child fields" and "link master fields"
properties and I got this error "Subform Field Linker Object or With block
variable not set"

What does this mean? and what do I do to get properties set?

Thanks for the help in advance.

-Justin
 
Hi, Justin.
What does this mean? and what do I do to get properties set?
Click to expand...

It means that the Wizard can't automatically set these properties for you.
Are both the main form and subform bound to queries or tables? Do you have
primary keys on both tables? Do you have a relationship established between
these two tables on fields that are of the same or compatible data types?
Create primary keys and a relationship and the error will likely be avoided.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
'69 Camaro said:
It means that the Wizard can't automatically set these properties for you.
Are both the main form and subform bound to queries or tables? Do you have
primary keys on both tables? Do you have a relationship established between
these two tables on fields that are of the same or compatible data types?
Create primary keys and a relationship and the error will likely be avoided.
Click to expand...

Yea I have primary keys and relationships. I figured it out though. I was
caused by the way I had initially created the subform. I changed things up
and it works fine now. Thanks for the suggestions.

-Justin
 
Back
Top