Add Unbound field to a form

[Dave14867]

I am embarrassed to ask this as I should know the answer but for the life of me I cannot figure it out. I have a table that has employee names, date of hire, birthday, etc. I created a query that shows me how long they have worked for the company, age, etc and that works great.



My issue is that I want to use that query result on a form as an unbound field but the field just shows "#Name?".

I am sure it is an easy fix but I just cannot figure it out for the life of me.

I cannot paste a copy of the file unfortunately.

[orange]

Dave,

See this link re unbound control on a form.

[Dave14867]

orange,

I had already done that and I get the "#Name?" as the result in the text box, I must be missing something. I have built the expression in the control source, used the query in the control source, same result.

I must be missing something foolish and I should know this, that what makes it so frustrating.

[davegri]

Are you using the DLookup function for the textbox control source? Is so,
1. What's the name of the query?
2. What's the name of the field in the query that you wish to display?
3. What's the criteria you are using to select the desired record in the query?
4. Is the lookup field in #3 numeric?

Finally what is the textbox control source that is giving you #Name?

[orange]

I agree with davegri --we need to see something in order to comment with focus.

[Micron]

My issue is that I want to use that query result on a form as an unbound field but the field just shows "#Name?".

What am I missing? If there is a query with a field that you want the textbox to show, why is the control unbound? Then again, the query has several fields so what exactly is supposed to be shown in the textbox? Surely not the values from all the fields in the query... Have to wonder if the form is bound or not. So many questions, so little info.

[ssanfu]

....... use that query result on a form as an unbound field .......

Yes, I know this is a bit nit-picky, but a field CANNOT be unbound. A field is part of a table.
You can, however, have an unbound CONTROL on a form.


But if you have a calculated column in a query, you can bind that calculated column to a control on the form. (what Micron said )

[Dave14867]

ssanfu,

Your absolutely correct, mis-statement on my part. I have though figured out what I needed to do and it is all set now. As usual I just had to think about it more, what comes so naturally to some doesn't for others, I am one of the others sometimes.

Thanks Folks. As usual your questions make me think more about what I am trying to do and lead me to the answer.