Control showing #NAME?

[Lifeseeker]

Hi,

I have a form based off of a query.

When I add this new control(bound) from the query, I keep getting #NAME even though I have checked that the column is there in the query.

I must be missing something here...

can anyone help me?

Thank you

 

[boblarson]

What type of control and what is your field's datatype? How are you adding this control?

 

[missinglinq]

If you run the Query independently does a parameter box pop up?

Linq ;0)>

 

[boblarson]

What is the control source look like of the control? You are using the field from the FORM'S record source aren't you? You aren't trying to add the field from the query like this:

=[QueryNameHere]![FieldNameHere]

are you? Because you can't do it that way.

 

[Lifeseeker]

What is the control source look like of the control? You are using the field from the FORM'S record source aren't you? You aren't trying to add the field from the query like this:

=[QueryNameHere]![FieldNameHere]

are you? Because you can't do it that way.

I think I solved the problem. Somehow it just takes longer for it to get reflected on the front-end. It was a field that I added in the back-end. After I waited for a bit, it started to show data.

Still strange though. Shouldn't it be instant?