use text value when form is dirty...

[gangel]

Hi people,

Hopefully i used the correct terminology!



I ahve a textbox [Name] that i have a keypress down event on (enter key = 13)
This event brings up a form based on forms!People![Name]

Issue:
It is using whatever was in [Name] before i started typing.

eg. if "adam" was in [name] even if i delete adam and type "Frank", when i press enter, the new form is still looking at "adam" as the text "frank" hasnt been 'saved' to the form as im still IN the text box...

Ideas?
Is it just a matter of "if press enter - change focus to next tab point then run the event" or is there another way?

[IrogSinta]

When you are referring to Forms!People![Name], you are really saying Forms!People![Name].Value, but you don't need to add the Value keyword because that is implied. However, if you want to get the current text of the textbox even while you are still editing it, you can use the Text keyword. I suggest that you adopt a naming convention when you refer to controls in your form. Using Name as a field name can cause problems because it is a reserved word. For textboxes, you can use the prefix txt in its name so in this case, it should be called txtName. You can use cbo (or cbx) for combo boxes, lst (or lbx) for listboxes, and so on.

So to see the text "adam", you would use Forms!People!txtName.Text

Ron

[gangel]

THAnks!

That solved it
I actually am using better fields and correct naaming, similar to what you suggested, the above was just an example to concentrate on the issue, not for you to have to learn all my box names etc But thanks for pointing it out anyway.

I do use txtName etc etc



Thanks for the .text answer, it sorted my problem out

Another thing learnt!