Search results

:eek: RG...I don't even know what to say. That little tweak is now allowing me to add ingredients to each recipe and it is storing it as I intended it to. I for the life of me would probably never have thought to go look there. My wife is super happy and amazed that there are people out there...

I'm looking into doing this but I need to be able to have each recipe hold each ingredient in a table where it can be referenced to at a later time...which I haven't been able to do yet. I do this on the Add Ingredient Form. She puts in the pounds and/or ounces and cost for items and it auto...

I tried it real quick and it's giving me all kinds of other problems now. I will dig a little deeper in a few minutes and see what I can come up with. As of right now, it's not doing what I want it to but I might be able to clean it up...we shall see.

So that gets rid of the problem I was having but now that has introduced a slew of other problems. I want each recipe to hold all of its unique ingredients per recipe. The way you have it, each ingredient is not unique to it's recipe. And then when I look at the recipe details page, that's...

Thanks RG. I'm striking out miserably.

I've tried that but to add multiple ingredients and then save them for each recipe doesn't work for me. I'll try to keep figuring this solution out because I know that it worked at one point in time.

RG, right. I got that. But how do I get it to create a new combo box once it's filled with the first ingredient since each recipe will surely have more than 1 ingredient?

I was using that to tie the ingredient to the actual recipe. I removed it and it didn't seem to change anything.

RG, I tried that at it still gives me the same error. Do you think I should just do away with the RecipeLines table all together and just use a ComboBox? But then how can I add multiple ingredients to a single recipe? That's really why I have that RecipeLines table since I don't know of...

Sorry...I'm not that advanced at Access and in my head, this was the easiest way to do what I needed it to do. It worked for quite some time and when I tried it today, nope. What is a good way to get around what I have done?

OK good...I was about to throw my computer out the window! Thanks for looking into it for me.

Hi all, Fairly new here and I'm having issues trying to figure out why all of a sudden a db I have and was working is no longer working. The database is something I created for my wife to save her time to figure out her cost of goods for soaping products she makes. I created it several months...