problems with field names in code

[automaticbaby]

I have a form that has a query as the record source. The query combines about 8 tables. Some of these tables have repetative field names, like First Name, Last Name, etc. I have code to open Word and populate bookmarks in Word.

Here's the code:

.Item("NominatedPerson").Range.Text = FirstName & " " & MiddleInitial & " " & LastName
.Item("CompanyName").Range.Text = Company
.Item("NominatedPerson2").Range.Text = [NominatedPerson].[FirstName] & " " & [NominatedPerson].[MiddleInitial] & " " & [NominatedPerson].[LastName]

The first line comes up blank (no data), the second line, which comes from the same table as the first line, has the correct data and the third line "can't find the field referred to in your expression."

It looks like I'm formatting something incorrectly, but it seems to work on some of the code, but not all of it. I'm using

.[Field Name] where there are conflicts with field names. Should it be something else? I don't open the query in the code because it's already the record source. Should I do that?

 

[fneily]

Partial code listing. If you're refering to, let's say, Firstname on the form, then it should be Me![Firstname]. If it's refering to some recordset you opened, then precede it with the recordset name, rs![Firstname].

I have a major problem with "The query combines about 8 tables. Some of these tables have repetative field names, like First Name, Last Name,"

It doesn't sound like your tables are normalized. If they're not, your database has problems.

 

[fneily]

Forgot to add, you may want to read:
Fundamentals of Relational Database Design

http://r937.com/relational.html