Displaying query results within a form

[Remster]

I want to display the results of a query within a form (for information for the person inputting data). The most common suggestion I've come across is to use a list box. I need the contents of the list box to be determined by a value that's entered elsewhere in the record in question. How do I achieve this?

[weekend00]

I need the contents of the list box to be determined by a value that's entered elsewhere in the record in question. How do I achieve this?

try a sub form, it can link to the main form.

[Remster]

try a sub form, it can link to the main form.

The problem is that I want the data to be there for information only, and I want it to be drawn from various sources using 'UNION'. Presumably I can't have the first two records in a subform autocomplete with values from one source (say) and the rest with values from another source.

[weekend00]

Although I am not 100% understand what you said, I think if you can get them into the list box, then you can in a subform.

If you want a listbox, you need to put some code in afterupdate event of the text box which contain the determine value. In the code, you can decide to show which value in the listbox.

[Remster]

Thanks for your advice. I've decided to go back to the drawing board and rethink my table relationships. Fortunately this is still at the experimental stage!

[pkstormy]

This works nicely:
https://www.accessforums.net/code-re...mple-7571.html

It lets you embed any query into a form.