"More Info" button based on Combo Box selection

[tcullenm3]

I need to create a command button that can be used to see all of the data in the table for whatever name is selected in a combo box. For example, if John Smith is selected from the combo box, the user could click a "More Info" button, which will open a seperate form showing all the data in the table for John Smith. I have searched and searched and how no luck figuring this out. Thanks in advance

[ajetrumpet]

how about a subform with some filter code behind the combo box afterupdate event? wouldn't that work? you wouldn't have to use 2 forms either.

[tcullenm3]

A subform may work, but they are looking to leave the main form with as little "clutter" as possible, so thats why they want the seperate form that will pop up only when requested.

In the event of using a subform, what type of filter code would i need to use? I assume I'd create a "more info" form, with whatever fields neccesary, then add that as a subform to my main form, but am not sure how to get the data to populate to the subform

[ajetrumpet]

a subform is easy. you can use an RS like so:

SELECT table.* FROM table WHERE table.field = forms!formname!filtercontrolname;

and then simply requery the subform control object when the button is clicked.

[tcullenm3]

Rookie question, what is "RS" ?

[ajetrumpet]

Rookie question, what is "RS" ?

recordsource. it's a property of a form. (NOT a subform control)

[tcullenm3]

Thanks, I will see if I can tinker with it from here