Open a subform in a form

[Cillies]

Hi,

I have one table with information about acronyms within it i.e. acronyms, description, details etc

What I want to do is: create a form with a search box on it, which will accept user input i.e. entering acronyms. then I want a button to click which will search the table for the exact match of the acronyms typed and display that associated information in a subform (or other method). I can create the form, the button and the subform, but I can't get the info to just open within the form, it always opens in a separate form. I think where I am getting confused it because I normally use subforms which contain data from different tables, but for this exercise I am only using one table. Hope this makes sense.

Regards

 

[Remou]

Have you got a subform control and a subform that you wish to use? You can set the Source Object of a Subform Control programmatically, however, from the description you give above, I think it would be better to simply set the Record Source for the form contained by the Subform Control.