At fange første record når man skifter til et nyt faneblad

Try using
IsNull(Me.ID)
Where ID is the primary key in the form.

If Me.NewRecord = True fanger om du er ved at oprette en ny record

Jeg kan ikke få det til at virke.

Cusoren står og blinker i det første felt, men jeg kan ikke spørge på det.
Hvis jeg bruger me.OrderID får jeg Method or datamamber not found.

Jeg har forsøgt med Tab.Value.OrderID, virker heller ikke. Jeg vil gætte på at jeg burde bruge Tab.Value til et eller andet, men hvad?

any chanc eof seeing the dB?
ekspertenATsanthell.dk

AT = @

If Len(Me.tbCurrentOrderID) = 0 Then Exit Sub

Oh yes, it works :-) but it's not good enough (only for a demo)

But it is impossible to get what field I'm actually in? I mean, the cursor IS in the field, I know the form, I know the Tab.Value so how do I get the field itself?

?
I'm not sure what you mean. If the record you are on is empty then the button doesnt open th eform which shows the record in detail.

It also (I think) works if you change which TAB you are on.

Can you explain in more detail?

Yes, your solution works if the record is empty and it works if I change to another tab.

But I have 2 reasons why I want to know this: 1) I like to learn ;) so I can use this lesson somewhere else, and 2) I like to make it easy for my users. So if they opens the formular and are standing at the right record (not empty) from the beginning, then they can just pres the button and go to the next formula. As it is now they'll have to click! somewhere in the record and then use the button.

So my question is: how do I know which field on the tab is the cursor located at? And I think this will be nice for me to know i a lot of other situations as well.

I understand you want to learn, I do too, but I wasnt, and maybe still arent sure what exactly you want to do.

Do you want to be able to double click on an existing record and open the other form without having to click the button?

I think you might be confusing things when you mention another form and another tab control!

terry, I can see my explanations are confusing, sorry. And I can see that my problem has changed as part of it is solved and then I have a new way of seeing the problem, well that's part of the learningprocess ;)

So I something that works allthough I would like it to work a little bit different. Let's close this quation and again, thanks for your help :)

Thanks, I'll send a comment to your email.