Solved Pulling Data from a Query Field to be Displayed in a Textbox (1 Viewer)

[Bean Machine]

Hi All!

I am wanting to pull the value from a field in a query to be displayed in a textbox. As seen in the image attached I tried referencing it as follows "[qry_SPL3]![fld_IDIT]" but this just gives me the "#Name?" error also as seen in attached.

Below is what the Query I am trying to pull from looks like.

Any help would be greatly appreciated. I am at a complete loss.

 

[plog]

I'd give a read to this:

Introduction to forms - Microsoft Support

Learn about the different types of forms in Access databases and how to create them.

support.microsoft.com

Generally a form is bound to a datasource (Table or Query). If that is the case, you simply set the control source like you did to the name of the field (you wouldn't also reference the datasource because the form knows). If you have an unbound form or want to reference a value in a datasource that the form is not bound to you need to use DLookup

MS Access: DLookup Function

This MSAccess tutorial explains how to use the Access DLookup function with syntax and examples. The Microsoft Access DLookup function returns a value from an Access table (or domain).

www.techonthenet.com

Instead of setting the control equal to the field you set it to the properly constructed Dlookup and it retrieves that value. Here's a very crude example that does not use your specific data:

=DLookup("[FieldName]", "DataSourceName")

 

[Bean Machine]

I'd give a read to this:

Introduction to forms - Microsoft Support

Learn about the different types of forms in Access databases and how to create them.

support.microsoft.com

Generally a form is bound to a datasource (Table or Query). If that is the case, you simply set the control source like you did to the name of the field (you wouldn't also reference the datasource because the form knows). If you have an unbound form or want to reference a value in a datasource that the form is not bound to you need to use DLookup

MS Access: DLookup Function

This MSAccess tutorial explains how to use the Access DLookup function with syntax and examples. The Microsoft Access DLookup function returns a value from an Access table (or domain).

www.techonthenet.com

Instead of setting the control equal to the field you set it to the properly constructed Dlookup and it retrieves that value. Here's a very crude example that does not use your specific data:

=DLookup("[FieldName]", "DataSourceName")

This worked great thank you so much for the help! I hope you have a great day!