Filter Form based on another Form (1 Viewer)

[joeKra]

Hi,
i have one form filtered based on a field value, now i want to open another form which has only the same member ID but not the actual field on what the first form had been filtered (so i cannot just use the same filter) , so what i want to do is that the 2nd form should only show the members which are in the first form

Thanks for advice !

 

[pbaldy]

Does this fit?

http://www.baldyweb.com/wherecondition.htm

 

[joeKra]

thanks for reply
No, this is not what i want, i want it should return all records shown in the first form, based on member ID , the first form have a field AmountSum but the 2nd form don't, so if i filter the first form on AmountSum i want the 2nd should show all the members showing in the first form

 

[joeKra]

is there anybody who can help???