Hello all,

Can I just say i have been lurking here for a couple of days after starting my Access 2003 VBA project(s) that I have to do for work.

Being a bit of an Excel VBA guru I thought i would have no problem picking it up. Oh Boy. How wrong can someone be. First time I tried to set the value of a txt box control and was told that not only did it need the focus but something else was wrong I knew I was in trouble.

Then trying to requery a sub form was not working.

I used the advanced search tip from here to search using google and both my problems were not only on here but the answers as well.

So you will probably see few more postings on here from me asking for help but for the moment thank you to all those who participate.

One last thing - Can I just say how refreshing it is to find a board where when someone gets something working they come back on and explain how they did it. I will try to do the same, although I suspect that what most of you all do is way beyond what i hope to achieve.

Chris

First time I tried to set the value of a txt box control and was told that not only did it need the focus
Slightly incorrect statement. It ONLY requires the focus if you use the .Text property and so you should normally use:

Me.YourTextBoxName = "Whatever"

This is the same as

Me.YourTextBoxName.Value = "Whatever"

since .Value is the default of most controls.

My Bad

That is exactly what I was typing in - txtBox.Text = "something"

And I had my first corruption of the database today. Again a quick forum search from Google got my work back (well minus the dodgy form) :)

That is what you get for trying to rush something before a meeting.