Hi Eric,
Could you please upload a small sample with just the two forms and empty tables?
Cheers,
Hi Eric,
Could you please upload a small sample with just the two forms and empty tables?
Cheers,
Hi Vlad,
See attached. It's the Adjustments form. Thanks for your help,
Eric
Hi Eric,
I have removed the filter on the form, added a dummy record and it seems to be working for me. Could you please have a look?
Cheers,
Hi Vlad,
Thanks for your quick response. I do see that it is populating but if you click add a new adjustment and click one record you created, the busunit is not updating, at least when I am running. What was the filter on the form you mentioned?
Thanks,
Eric
Hi Eric, please see the latest. You need to specify how and when you get the solution "not working" . The filter was saved with the form and was set to load on open, have a look at the file you updated and you'll see it.
I would strongly recommend you get rid of all the loookup fields in your tables, they will be causing you hours of grief....see detailed info here:http://access.mvps.org/access/lookupfields.htm
Cheers,
Vlad
Thank you Vlad. Sorry for not being more specific last night... but I'm glad to see you figured it out. So I removed the form filter, copied your code exactly from your Vlad2 database and the business unit field is not updating when I open the adjustments form or when I click on create new adjustment and select a CCA. I will try to review all the code and settings side by side to see if I can find what the difference may be. It's really a head scratcher. Also, thanks for the info on the look ups. I had no idea they were so disruptive to queries. I will remove them from my main database. I'll let you know what I find with the business unit field.
Thanks again,
Eric
Hi Eric,
Please have a look at this update, I think this is the easiest to implement, basically remove all previous code and put this expression in the control source for the business unit textbox on the main form:
=DLookUp("[BusinessUnit]","[t_CCA]","[CCA#]='" & [CCA#] & "'")
Cheers,
Vlad
Hi Vlad.... Perfect!
Thanks again for sticking with me so long. I hope you find my future posts.
Take care,
Eric
Glad to hear you got it working!
With your forum handle ... probably
Cheers,
Vlad