Changing field value after form record source change

[LARiot]

Hi. Thanks for looking into this. Any help is appreciated.

I have a form and every time the user clicks on a new tab, the record source of the table changes. However, in the VBA I cannot reference the field. It only shows the fields from the original record source. When I type it in anyway it says Method or data member not found. I've done a requery already (right after the record source change) but no use. Any advice? Will I have to do a INSERT from SQL? Seems like I should be able to do it through a simple me.ImagePath1 = "C:\blahblahblah".

Thanks

-Nima
"Pluralitas non est ponenda sine necessitate", i.e., "Plurality is not to be posited without necessity" aka K.I.S.S. (Keep It Short and Simple) -- Ockham's Razor

 

[PHV]

Don't reference the field but the control.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[LARiot]

That's actually where the whole problem started. I can't change the image's control source through VBA.

-Nima
"Pluralitas non est ponenda sine necessitate", i.e., "Plurality is not to be posited without necessity" aka K.I.S.S. (Keep It Short and Simple) -- Ockham's Razor

 

[LARiot]

I just did an update using DoCmd.RunSQL and it's working fine now. Apparently the control source (which can't be updated through code) supersedes the Picture property.

Further proof that Microsoft uses voodoo and witchcraft in applications.

-Nima
"Pluralitas non est ponenda sine necessitate", i.e., "Plurality is not to be posited without necessity" aka K.I.S.S. (Keep It Short and Simple) -- Ockham's Razor