Displaying All Results of a Query on One Sheet of Form

[nick404]

Hi,


I would like to be able to display all the results of a query in one sheet of a form, much like how a report displays them. The reason I need a query is, however, there are some field the user has to input information into (this will end up being a purchasing order form for a company). Things like credit card, who is requesting the purchase, approved by, supplier name, etc. will have to be entered in manually, thus I cannot use a report. Anyways, I need a way to display all the results of a query on a single sheet of a form. Thanks!

Nick

[cbende2]

How do you want it set up?

You could use just a continuous form:

When you create your form, go to Property Sheet>Format>Default View: "Continuous Form"

[nick404]

Yea that layout is what i want thanks! Now is there a way to get a total price to appear after the last record? Rather than being in the form footer...

[cbende2]

You're welcome!

And no, I'm pretty sure you will have to calculate total in the footer.

[nick404]

And one other arising issue, how can I allowed data entry into a form for certain textboxes, but restrict it for others? Specifically, the information the user has to manually input is in the header, and the query results are in the body of the form. Perhaps it is possible to allow data entry in only the header? Not sure how to go about this...

Since when I allow data entry for the form my query results disappear, and when I don't allow data entry the query results are present.

[nick404]

Well I was able to get the query results to still show while allowing edits, but any way I can restrict edits to the query results? Also, can I get the form to not bring up a new row for data entry? The form will eventually be printed and I don't want an extra blank line there.

[cbende2]

Nick, as for the new row for data entry, you can disable this.

Got to Property Sheet>Data>Allow Additions: No

This will remove the blank record at the bottom.

And I can't quite understand the first part of your question. Can you explain a little more? Maybe a screenshot or something?

[nick404]

Here is an image of what I have going on. As written in the picture I want to somehow allow the user to type information in the top section (the header, blue) but restrict them from typing anything in the body part of the form (red). If I change the property 'Data Entry' to Yes, then it erases my query results. [The query results are the section of red]. This isn't a major issue, just something that would be helpful.

[June7]

Data controls Locked property can be set to Yes to prevent editing.

[cbende2]

Are the query results constantly updating as you type returning new results?

If this is the case, you may have to modify it to run the query once you are finished typing in the control.

[nick404]

Thanks for the help!