Query by Form and Print Help

[Tom Patten]

Hi,

I cannot seem to figure this out. Even after searching on the topic and finding quite a bit.

I have a form on which I run a query by form which works. I have a browse at the parent level so I can check the results easily.

I have a simple report, with "base report on current selection of records" selected. Now I run my query, and preview my report, but it shows all records.

Two things: the query_by_form is located on a tabbed object, but as I say, it works. And when I exit A5, I have mpx files in my directory. I delete them and try again, but still no go. Again the query itself works.

Is there a way to do this (I can't seem to figure it out):

report.preview( "my report", "Last query", "Order field")

Thanks for taking a look

Tom

[Tom Cone Jr]

RE: Query by Form and Print Help

Tom,

confirm that the report is based on the same set as the form.


If you open the form, run the query, close the form, open the default form for the same set, is the query still in place?

-- tom

[Tom Patten]

RE: Query by Form and Print Help

Tom,

You got it - I didn't have the report based on the set. I had it based on the parent of the set.

Thank You.. Thank You

Hope to see you in May and thank you in person.

Tom

[Segulah]

Re: Query by Form and Print Help

Dear Tom (Cone),

Since upgrading to v. 8, it seemed to me that reports in which "base report on current selection of records" give the same behavior as Tom Patten reported. I have searched off and on in the message board to find someone else with this problem, and was thrilled to finally find this post. My situation is a bit different apparently:

1. I use find by form to select records (not Query). The find_by_form method is bound to the On_Push event of a button on the form.

2. Both the form and the report are based on the same table (not a set).

I thought the last item was the problem after reading your post, but it isn't. The strange thing is that this same report seemed to work fine in the previous two to four versions (I'm not sure when I first created it), but doesn't now. It DOES work if I do a query, so I decided to to change the XBasic to query_by_form(). That worked, but it does cause a slight inconvenience to the user: now they must use a wildcard symbol (*) if they do not want to type the entire string in a field. With find_by_form, they only had to get the first part correct.

Do you know of any way to pass the current query to the report if one uses Find By Form? The query shows up in the "Select Index/Query" list window, so I don't understand why it isn't passed. Also, I think I used this method in version 7 and it worked. Could it be that some code in Alpha Five v. 7 wasn't inherited by v. 8? (I guess I could reinstall v. 7 and redo the form to test this, but I don't think I want to do that.)

[Tom Cone Jr]

Re: Query by Form and Print Help

I never use Find by Form when I'm trying to limit the range of viewable records to a subset of the total range. I use a query to limit the range of viewable records, instead. So far as I know, FBF does not establish a query list that can be used by other processes. i.e. If you run FBF to locate a record and then close the form, what view of the data is presented if you then open the default form for the set? This is what your report layout sees.