Retrieving form values

[anth1977]

I'm trying to write some basic code to pull the values of two text boxes on an access form. However, I have found the only way to do such is to first set the field's focus and then grab the values. This forces the user to see
the setfocus actions, and with 10 fields, that can be very annoying. Any suggestions? The code is in a VBA module.


Dim strusername as string, strpassword as string
txtusername.setfocus
strusername = txtusername.text
txtpassword.setfocus
strpassword = txtpassword.text

Thanks!

-Anthony

 

[WildHare]

It seems unclear as to why you're doing this. Why can't you just use txtUserName and txtPassword in your processing?

Remember, you're unique - just like everyone else
You're invited to visit another free Access forum:

http://www.forumco.com/jmhare

or my site,

http://www.jmhare.com

 

[phillipcounce]

Try This instead

Dim strusername as string, strpassword as string
'txtusername.setfocus
strusername = txtusername.value
'txtpassword.setfocus
strpassword = txtpassword.value

This will read the contents of the text box with forceing you to set the focus

 

[larryww]

In my experience, SetFocus *is* required before changing the contents of a textbox (in code). Am I mistaken?

This is a different question than the thread. I am asking about writing to a text box, not reading from one.

 

[WildHare]

I think you should be able to reference TextBox.VALUE without having to set the focus there first.

Jim There are two ways to argue with a woman - neither one works.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[larryww]

Thanks, Jim - I'm unable to reproduce the problem now anyway; I suspect it was an issue with a prior Access version.