Filter combobox based on the last end point

[ivandgreat]

Hello,

Good day. I have a table which has a "Start" and "End" fields, and i made a query based on this fields which continues to look up the next points until the last end points.

I wanted to filter the last end points on the query table that was related on the combobox value.

Anyone could help me on this.

Thanks!

ivan

 

[ivandgreat]

anyone could help me on this. Thanks!

 

[John Big Booty]

Which form are we talking about

 

[ivandgreat]

Which form are we talking about

It was on the "IDs" form.

Could you please help me on this.

I only wanted to filter the last end IDs based on the query "QueryCasID subform" on my form.

Ex. if i choose ID "2000", the query will filter on the "Input.Start" field the value of ID 2100, since this is the last point of ID 2000. As well for IDs 2200, 2002, 2001 and 2100.

br,
ivan