Table name in listbox

[Spikemannen]

Hi,

I have a problem with a listbox that uses a querie to show posts.
In the header of the listbox the fieldnames is showed like:
tblTable.Object instead of only Object.

In the querie there are two fields that has the same name.
Object from tblTable and Object from tblObjects, I think thats where the
problem could be.

I could really need som help here please...

 

[Lister]

Sounds like you want to be using a alias.
See if this helps.
In your query you have a field name Object.
In your underlying query use the alias.

Object: [Your Field Name]

You will have to make sure that your list boxes RowSource is looking at the new query and not the SQL statement.

So in you list header it will show "Object".