Hi all,
Basically I have what is probably some sort of brain blockage on my part but I could use some assistance.
I have a form which contains an unbound combo box and two unbound date boxes that provide inout to a select query and a command button to run the query. No issues there, form works as expected and the query outputs the correct information in a seperate window in datasheet mode.
What I am trying to do is to display that information (results of the query)in a subform on the original form with the combo box and text boxes. I have tried various approachs to this and basically get the same error which is that I cannot link two unbound forms. I have also tried putting the combo box, text boxes and command button in the header section of a form and again no problems with the query working, but no joy in getting the results to display as I would like.
I have also created a form that is bound to the query and again same reults. It will display the results of the query but not in a subform.
Is what I am asking access to do possible or is it something simple that I have forgotten about the program?
Basically I have what is probably some sort of brain blockage on my part but I could use some assistance.
I have a form which contains an unbound combo box and two unbound date boxes that provide inout to a select query and a command button to run the query. No issues there, form works as expected and the query outputs the correct information in a seperate window in datasheet mode.
What I am trying to do is to display that information (results of the query)in a subform on the original form with the combo box and text boxes. I have tried various approachs to this and basically get the same error which is that I cannot link two unbound forms. I have also tried putting the combo box, text boxes and command button in the header section of a form and again no problems with the query working, but no joy in getting the results to display as I would like.
I have also created a form that is bound to the query and again same reults. It will display the results of the query but not in a subform.
Is what I am asking access to do possible or is it something simple that I have forgotten about the program?
