I have a form that gets user inform

[soontobefour]

I have a form that gets user information, when done they click on the "search" button which is to launch another form and on that form display the results of a query.

this is the code on the new form launched:
Me.RecordSource = &quot;SELECT Reservation.Room, Rooms.Capacity FROM Reservation LEFT JOIN Rooms ON Reservation.Room = Rooms.Rooms GROUP BY Reservation.Room, Reservation.Date, Reservation.Start_Time, Rooms.Capacity HAVING (((Reservation.Date)=#&quot; & Forms!Roombydate_time!Text2 & &quot;#) AND ((Reservation.Start_Time)<>#&quot; & Forms!Roombydate_time!Text4 & &quot;#))&quot;
MsgBox RecordSource

the msgbox does show me the Selest statement with the values from the user. But I don't know how to display the results on the form.

any suggestions?

thanks,
soontobefour

 

[VivP]

A data sheet or continous form I would suggest. You can use the 'on double-click' property to do an actions you need when the user decides to do anything. I that what you mean't?

Viv Viv Paton
Access Developer

 

[soontobefour]

Viv,

The results I would like to display is the room and capacity for the rooms that are available. I want it displayed on another form. How do I do that?

 

[VivP]

I would suggest that you paste the SQL (minus the criteria statement) into the form's record source and then set up a line of text boxes in the detail section of the new form. Bind these to the fields you wish to display, and then change the Form's 'Default View' property to 'Continuous Forms'. Viv Paton
Access Developer