Hi

I'm trying to update a table but am having trouble referencing fields within a subform of a form. Is it possible to do this?



Cheers
Tony

__________________
Cheers
Tony

Yep.

Oh come on Brian. Throw the man a bone!

subform_object_name.Form.sub_form_field_name

The key being that you have to put the ".Form" in to indicate that you want to look within the properties of the subform. You will not get Intellisense to tell you the name of the field.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org

cheers Randall...shame on you Brian

Cheers
Tony

Well, gee Tony. I was hoping to get you to post just a little of what [u]exactly</u> you were trying to accomplish. I don’t think that I concur that this is a cause for shame on my part.

It seems to me that when you are asking for help you should be a little more forthcoming about what the situation is. I mean, that seems reasonable, don't you think? Even when my wife says to me, “Can you help me?”—leaving it at that—my response always is “I don’t know; what is it that you need?” If she asks me if I’ll do her a favor, I always wait to know what it is before I answer.

This is a way of doing things that I adopted after reading Heinlein’s [sp?] Stranger in a Strange Land, being impressed with the behavior and the whole idea of the professional witnesses in that book.

Brian, you are a funny guy!

Of course I agree with you wholeheartedly! Give us enough of a clue so we don't spend extra time answering the wrong question.

And while we're on this tirade. I wish method (who was the first person I saw receive admonishment from Brian), would please do some of his own research. Makes me want to stop answering his questions. And then when he asks the exact same question in different threads I'm even more apt to let him go it alone. (See: http://p2p.wrox.com/topic.asp?TOPIC_ID=27987 and http://p2p.wrox.com/topic.asp?TOPIC_ID=27774)

Okay. I'm done.

Well, one more thing.... In this case I think Brian's first answer was pretty appropriate. No offense Hudson40, but ask a Yes or No question, get a Yes or No answer.

Now I'm done.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org

What you want hudson40 is:

Forms!form_name.nameof_subform.Form.recordsource=s tring of criteria

do it all together instead of selecting fields

change data, edit and:

tabledef
with
edit.or add.

update.
end with

etc, etc...

Fokes aren't very helpfull setting levels in a no game zone.

Funny. I thought the question was already answered???

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org

You don't need VBA to access fields in a table.
You need VBA to control data to and from a table.
The prople answer is "look for the Control Source property of the control in design view".