How to Retreive Values

Sankaran_Balasubramonian

Dear Sirs,

I am trying to do the following.
I have two forms
1. GRN Header
2. GRN Line. I have two tables for the corresponding forms.

I have added the form GRN Line in the GRN Header form using the subformlink property.

When I select a GRN Number in the header, I want only the line items for that particular Header. But now all the available Line items in the table are being shown in the subform.

I wrote a small code setting filter. It didnot work.

Please advice.

Thanks in Advance

Balaji

bbrown

Set the SubFormLink on the property sheet of the subform.

Sankaran_Balasubramonian

Hi

Thanks for the reply. It worked.
I have another doubt.

I have made the subform with the following fields
PO No
Item
QTY
RATE
COST

I am gettign an error message when I try to enter the secind line in the form.
The message is as follows

GRN LINE PO NUMBER 'PO00101' ALREADY EXISTS

GRN LINE - My Table
PO NUMBER - A field in the table.

Please advice.

Thanks
Balaji

Marije_Brummel

What is the primairy key of your line table? This should be some document no. and line no.

In order to activate the line no. you need to activate the autosplitkey property on the subform.