G
Guest
Folks,
I have successfully set up a QBF Query By Form using the instructions at http://support.microsoft.com/kb/304428/EN-US/ . Everything works just fine, and I can search to my heart's content. The problem is that the results of the QBF are displayed in a datasheet, which is neither pretty, nor user-friendly. How would I go about displaying those results in a Form instead?
Ideally, I would be able to embed the display form in the search form as a subform, but that's a whole other topic, so the long and the short of it is this:
Without knowledge of SQL to speak of, how can I create a search form like the one described at http://support.microsoft.com/kb/304428/EN-US/ that presents the results of the search in a form?
Thank you for your consideration,
Tom
PS: VBA code is OK. My VBA experience is mostly limited to Excel, but I'm happy to put in the effort to get comfortable in Access.
I have successfully set up a QBF Query By Form using the instructions at http://support.microsoft.com/kb/304428/EN-US/ . Everything works just fine, and I can search to my heart's content. The problem is that the results of the QBF are displayed in a datasheet, which is neither pretty, nor user-friendly. How would I go about displaying those results in a Form instead?
Ideally, I would be able to embed the display form in the search form as a subform, but that's a whole other topic, so the long and the short of it is this:
Without knowledge of SQL to speak of, how can I create a search form like the one described at http://support.microsoft.com/kb/304428/EN-US/ that presents the results of the search in a form?
Thank you for your consideration,
Tom
PS: VBA code is OK. My VBA experience is mostly limited to Excel, but I'm happy to put in the effort to get comfortable in Access.