opening a form applying a filter argument

[Ewald]

I was just working through the following thread
http://www.oooforum.org/forum/viewtopic.phtml?t=30405
which tells how to open form2 using a command button on form1. Opening form2 works like a charm.
What I would need though is that form2 opens with a filter applied based on an IDField value located on form1. In other words: form1 has a field named IDStudent and I want form2 to be filtered on the IDStudent field using the current IDStudent value in form1 when I hit the command button.
How do I get the value and pass it on to the macro opening form2?

[mobi-doc]

The following code is on the form1, opens form2 and apply a filter:

[Ewald]

Tanks mobi-doc. The code works with one little caveat: how do I get the filter string from the control IDStudent on form1?

if I enter .....oF1.getString(IDStudent) or oF1.getString("IDStudent") I keep getting an error message saying SQL Status:
HY000
Error code: 1000
SELECT * FROM "tbStudent" WHERE filtered_field =
syntax error, unexpected $end

[mobi-doc]

getString accepts an integer argument. For example if you want to get the 1st field of your result set or form then give a 1.

It is better to install OOo SDK only to have local access to IDL library to see each method in detail. And the XRay tool would be useful too!

[Ewald]

Thanks mobi-doc. I did get the SDK and the x-ray tool. I also installed OOo2.2 (was on 2.1 so far).
Now your code gives a syntax error in the following line:
prop(0).Name="ActiveConnection"

When using OOo2.1 the code works (I have OOo 2 on a different computer, both running XP).
Another question: how do I find out about the order of the controls on a form?
Does this code also work, when the filter argument is on a subform?

[mobi-doc]

[Ewald]

The Details are:

I installed OOo2.2 on my Desktop, installed SDK and x-ray tools.
Then I copied the database I am currently putting together on the desktop.
When I hit the button having your code from above, I get the error message:

"Basic Syntax Error", the following line is marked:
prop(0).Name="ActiveConnection"

The very same code gives the desired funtionality in the very same database running on my laptop which has OOo2.1 installed. Both machines are running XP.

[Ewald]

I found out about the Basic syntax error:

When I place the macro to open form2 (see above) under My Macros>Standard I get the behaviour described above.
When I place the very same Macro under the Standard macros of form1 then it works just fine.
Seems very strange to me but then all I have learned so far is MSAccess and visual basic which doesn't seem to be helpful at all when working with OOo.

Thank's a bunch, I'll keep asking those questions as they come up.

[mobi-doc]

The code is designed to run from the form document itself. That's why it doesn't run when installed on MyMacros library container.

ThisComponent is a BASIC statement that represents the model of the component the currently running code is resided. I don't know what ThisComponent represents when is placed on code residing on MyMacros library container.

There are no so much differences between StarBASIC and VBA. The real differences are on component models which is UNO for OpenOffice and (whater is for this month for microsoft windows, I forgot to check )

When I decided to work with Base, the first impression was dissapointing. But with step by step learning I built something useful. So don't be dissapointed.