Make the Display Name Different from Source Name 1

[TwoOdd]

I have created a continuos form that is based off of a query. After I did all of the programming, we decided that we wanted the column names to read differently from the field names (i.e. instead of fldItemCode display Item Code). Not a problem, in the form field properties I left the control source to point to the field from the query and I changed the Name. This works just fine on my computer.

The problem is that on some computers, I get a #Name? error on some of the fields.

A little more information...

When the user selects an Item Code, the information about that item gets populated in the rest of the fields (i.e. description, cost, etc). These are the fields that come up with the error.

I thought it wasn't querying all of the data. But even when the user exits the form and reopens it (in essence requerying the data), - I even did a form.requery after the item code was updated - the errors are still there. It seems to be a conflict between the Name and the Control Source.

Yes, I could change the query to read "fldItemCode as [Item Code]" as this would allow me to make the Name and the Control Source the same thing, but then I would have to rewrite a ton of code.

Besides, this is a feature that should work.

Any insight would be appreciated. If more information is required, please ask.

Thanks,

TwoOdd
--------------
Good judgment comes from experience, and experience comes from bad judgment.
-- Barry LePatner

 

[CautionMP]

TwoOdd,
Are talking about a continuous form, or datasheet view?

Either way change the Caption on the Child Label since this will control what the users see as the 'Field Name'.

CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[TwoOdd]

Sorry, it's a datasheet view. I thought the datasheet view pulled the column names from the fields not the labels, so I deleted the labels. Doh! Therefore I was changing the text box properties (name and control source) - it all went wrong when I deleted the labels.

Thanks for the insight on the labels. It worked like a charm.

TwoOdd
--------------
Good judgment comes from experience, and experience comes from bad judgment.
-- Barry LePatner