Hi there and welcome
Am I able to look at the file?
you can upload it to www.wikisend.com
and provide me the download link
I have never used wikisend?? Is there another method to send it to you?
thanks go it
where is the function located?
Formula Table Form - if you go to Design View you will see it.
ok, looking now
ok, can you tell me what you want to show there please
Yes - I would like it to return the "Fat %age" from the Raw Material Data table based upon the RM Product Code entered in RM Input 1 - once you solve that for me - I can do RM Input 2 through 8
ok, something is causing the form to crash, its not the formulars
do you have code written anywhere in the forms?
ok, believe I found the problem
open the database, then click on the top left Office Button
Choose Manage, then Compact and Repair Database
once done, test please and let me know if you still have the problem
how did it go?
Now I get the error #Name!
can you tell me what that field should be displaying and how?
The one returning the #Name
Yes, when you select a raw material on the Formula Table form [RM Input 1] - the field showing #Name! should be returning the value for the corresponding field [Fat %age] for that raw material selected in [RM Input 1] from the Raw Material Data Table
For example - if I type in (or select) 80060 for RM Input 1, the Fat Percentage should be 22% - see 80060 in the Raw Material data Table.
ok, test it using this lookup please
=DLookUp("Fat %age","Raw Material Data","[RM Product] =" & [Forms]![Formula Table]![RM Input 1])
No - that provides #Error! - do you still have the file??
can you send it to me again pelase
i see you did RM Product Code instead of RM Product as i typed
can you copy my formula and paste it exactly as provided please
I did - both returned #Error!
ok, I am not sure why this is not working
I will opt out for another expert that may be able to resolve this for you
OK - thank you - what do I need to do??