Recent content by SteveI

Does anybody have any idea how to do an autofill using a query. e.g. if the product code is entered it will complete the price of product (lookup and coding not an option) thank you

thanks but does the subform in the main form not lookup the ingredients in the ingredients table already. or is the lookup table something totally new - can you be more specific.

Hi, I want the attached database to update automatically. I.e. when I change the description of the ingredient from Sugar to Brown Sugar In the Ingredient Table - I want all the recipes that contain sugar to change descriptions to Brown Sugar in the Recipe/RecipeIngredient Table. Is this...

thanks for your reply. I am working on a chemical formulation database (hence the similarity to recipes). Sometimes names change for chemicals which means that I cannot change each and every single component. e.g. what if water was called Aqua tomorrow. But what I have noticed is that previously...

my concern is however that it will be a user database and if the user updates the ingredients in the Ingredient Table from Flour to Wheat Flour - this needs to be reflected in the Recipe Table for ALL recipes containing Flour. :confused: (the forms that update the fields are not based on queries)

Hi I am not sure I understand how records update. for example if a description changes - how does this change throughout the database automatically. e.g. if the recipe contains a sub field that contains ingredients such as flour - but now the description of flour has change to Wheat Flour...

Why does a dialog box (SEE ATTACHED) come up for an applyfilter macro written based on a query occur. The where condition for the apply filter is as follows: [INCI Name] Like "*" & [Forms]![INCI Name Search]![Text57] & "*" :banghead: Many thanks

It is easier to base a report on a query - and place 'Is Null' within the criteria box for that value.

How does one suppress printing of a field when the field contains a value (i.e. a date).

Is it possible to attach a subform2 to subform1. Subform1 is already attached to a mainform. e.g. Recipe Info = Main form (Apple Pie) Recipe Ingredients = Subform1 (Flour, Milk, eggs) Ingredient Breakdown (Flour = baking soda + wheat + salt) The relationships between primary...

thank you. It worked!!

Please assist...Is it possible for a DLookup code to work when the lookup filed is a text field. It works when it is a number field.

I want to access Form 2 via Form 1 by means of a button. The information on Form 1 (contains a recipe) is related to form two and exists via a valid relationship within the tables. Form2 contains information about the recipe i.e. instructions on how to make the recipe in form in strict...

Thanks. It is what I am trying to do. The only difference is that I need to open the header and then formulate a product - I do however need the autofill to pick up in the detail section to copy into the table1 which is linked to the formula table via ID2-ID. - i.e. I need to select the...

Thanks I will rename and give it a primary key. The RI Table contains the ingredients to make the formula/recipe hence the reason I need to pick up from the RI Table and drop into the Subform via autofill (Table1). The Formula Table is the main table that contains all the details about the...