Display a query result on a form

[NannyOgg]

Hi all

I'm not sure if I should ask this in forms or queries but can someone please tell me if I can display the results of a query in a form that is based on a table?

And if this is possible then how?

Thank you.

 

[dcx693]

If you base the form on the query instead of the table, then you can display the results within it.

 

[NannyOgg]

If you base the form on the query instead of the table, then you can display the results within it.

Thanks

I think you misunderstood.

The form I have is used to display and enter information in a table. On this form I want to put a textbox that displays information from a query.

Access gives me a choice to base a form or a subform on a table and a query but if I try to include information from both I get a message telling me that I can’t do it.

 

[dcx693]

A single form (or subform) can only be bound to one table or query at a time, and the form and subform can be bound to different tables or queries.

What I think you want is to have some information bound to a table (the fields that you are using the enter information) and some unbound controls to display information from that query.

Forms and controls can be bound or unbound, but they can only be bound to one source at a time. Just use a mixture of bound and unbound controls. I often use a listbox to display query results. Sometimes I'll use a subform.

 

[NannyOgg]

Thank you.

I have now tried using a list box and a combo box and this works but it displays information for every item in the query and I only want the information pertinent to the item displayed on my form.

I can't seem to get an unbound control or a sub form to display anything other than #Name. I presume that this is indicating an error?

Perhaps you could help me a little on this?

I don't even know what to look for I have tried searching the forum but I just get loads of replies that are just confusing and don't seem to tell me what I need to know.

Once again, Thanks.