MsAccess programming in dynamic header and details

[benz_jie2005]

---

I'm quite don't have enough knowledge on MsAccess, in my previous experienced I've always place a static field label in the forms header and detail values. Can someone advise me on how to design a form to be a dynamic such that there corresponding heading and values will depend on the queries values..like for the example the queries results got 5 heading and its corresponding values,, so will it result on 4 or more heading and values, I want that my forms will also get exactly from queries..

If you have done this in the past, would you be willing to attach or email me a sample Access database or sample code?, my email add is benzjie@gmail.com. Your help are highly appreciated in order for my problem will be solve.

[dlanyer77]

bro pm me and attached the screen shot of the window so i can visualized what you need for your output. it would be fine if you can put some label on the captured window to be more precise.