#Error when Subform blank

[Gicu]

Hi Eric,
Could you please upload a small sample with just the two forms and empty tables?
Cheers,

[DefinitelyMaybe]

Hi Vlad,

See attached. It's the Adjustments form. Thanks for your help,

Eric

[Gicu]

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,

[DefinitelyMaybe]

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

[Gicu]

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

[DefinitelyMaybe]

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

[Gicu]

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

[DefinitelyMaybe]

Hi Vlad.... Perfect!

Thanks again for sticking with me so long. I hope you find my future posts.

Take care,

Eric

[Gicu]

Glad to hear you got it working!
With your forum handle ... probably

Cheers,
Vlad