Reading this code

[NoDBExperience]

Can anybody please tell me what the exclamation mark between materials and publisher mean?

This was copied nad pasted from another table which doesn't work on this form?

[Materials]![Publisher]

How can i take data from another table and list it onto a report??
Does that data table need to be binded to the report?

[jamjar]

[Materials]![Publisher] should indicate the control named 'Publishers' on the form named 'Materials'.

As for the second part of your question, "How can i take data from another table and list it onto a report?? Does that data table need to be binded to the report?", I think it sounds like you are trying to build a report with elements from two or more different tables? .... in which case you would need to:

• build a query to join the tables,
• extract the data you want for the report,
• and then build the report based on that query

A form might have controls bound to tables or queries, but to the best of my knowledge a report does not.

cheers-
James
SomeDBExperienceButNotAnExpert

[MMcCarthy]

Can anybody please tell me what the exclamation mark between materials and publisher mean?

This was copied nad pasted from another table which doesn't work on this form?

[Materials]![Publisher]

How can i take data from another table and list it onto a report??
Does that data table need to be binded to the report?

If this is on a form in a control then it is the Publisher field in the Materials table. Open the form in design view and check the properties for this textbox. Go to the data tab and look at the Control source. This should be a dropdown list of all fields available to this form. Look for the Publisher field.

Mary