dlook up and setfocus

[msasan1367]

Copy.mdb
Please see my program
It has 3 forms:
1- calc


2-endcalc
3-endcalcsub
and 1 table: cmp

I want enter a number in calc form textbox, example: 2, when I click on calc button it opens endcalc and focuses on "2.07" cell which is more than 2.
if I enter 4.5 it focuses on "4.81" cell in endcalc form
please help me, thanks

[rpeare]

You're making this way more complex than it needs to be I think.

You just want to find the first value in your table AFTER the number entered in a text field, you don't really care about all the other values, right?

So in other words, for your example, if you put in 2, you'd only want the record with 2.07 to appear?

[msasan1367]

You're making this way more complex than it needs to be I think.

You just want to find the first value in your table AFTER the number entered in a text field, you don't really care about all the other values, right?

So in other words, for your example, if you put in 2, you'd only want the record with 2.07 to appear?

yes, that's right. how to do that?

[rpeare]

Copy.zip

note the use of a query using the TOP clause to return the first value AFTER the number chosen.

You can just as easily build the form on a SQL statement I just broke it out so it's easier to see.