Search results

I think I will do myself a bigger favor and ignore your asinine comment.

Gad... okay I just figured this out. I need to set a recordsource for the subform at startup if I want to change the recordsource later. I created a saved query based on the SQL statement I wrote with the first sandwich ID and used that as the recordsource. I then was able to change it...

The subform is in the main form. The subform is named 'SandwichSuborm' It is in datasheet mode and has NO recordsource or Query assigned to it at startup. I cannot use a saved query as I have no idea what the sandwich Id number I need to look up will be and I would need to modify the query...

I should clarify that I want to use the subform to allow the user to easily change the number of servings. The subform would be populated with the information and the user simply changes the serving number (allowing for more of any ingredient)

I currently have a query that a subform uses to display some results. In this case, there are 3 columns displaying the name of a sandwich, the ingredients, and the number of servings of each ingredient. It looks like this: SandwichName IngredientName Servings Accordian...

It is a datasheet - a blank datasheet at present although I can certainly populate it with the contents of the table I described in my first post. There are about 80 items in the table however so ideally I would start with a blank datasheet, the user would select an item from one of the list...

I thought I was asking a quick question: how to reference a subform from a main form. I didn't expect that question to be controversial and require cheekiness and misdirection. Hopefully you are not indicative of the population on this forum. I asked here because I thought it would yield a...

Thank you - no where in that link is the question "How do I make a VBA call from my form to the subform" answered but it does provide a very simple picture of what a subform is and how to add it to a page. It is as Dilbert once stated a huge binder full of information that at first glance looks...

Okay - I can see some cross over in that you're building a nice long string of data to place into the subform without actually putting it there which unfortunately is where I am stuck. I can build a string using a loop but I do not know how to target the subform for this data? From your...

Also - this appears to be attempting to send an email - I want to update a subform inside of Access 2007 not format / send an email.

I'm afraid I owe you an apology - I should have stated that I am doing this inside of Access 2007 - an Access form.

Hello, I have five list boxes set to a table in my database. Here is what a few rows in my table look like... ID IngredientName IngredientType Cost 1 Ham Meat $1.23 2 Beef Meat $3.45 ...