VB Run Time Error 438

[Guest]

Object doesn't support this property or method.

I have an input screen containing 5 contact names.
When the user enters these or changes them I want to create/update a further
field on my table that is a memo field made up of the 5 contact names. This
field is going to be used later on in the application.

Has anyone any suggestions as to how this can be done?
I have tried but am getting the above error.

 

[Brendan Reynolds]

It would help if you could show the line of code that raises the error,
along with the declaration and instantiation of any variables used in that
line.

 

[Guest]

Me!Contacts = Me!Contact1Name & Me!Contact2Name etc.
Contacts is the memo field and the others are the 5 contact names.
I do this as an Event Procedure on the Before Update property.
P.S. I am not a VB programmer so forgive me if I am doing something stupid.

 

[Brendan Reynolds]

Is the form bound directly to a table, or is it bound to a SQL statement or
saved query? If it is bound to a SQL statement or saved query, is the field
'Contacts' included in the SELECT clause? If it isn't, the code behind the
form will not recognize 'Contacts' as a property of the form.