Autofill into Tables (from Forms)

[SteveI]

How does one autofill into a table from a form. Can anyone assist. DB attached.
tx
S.

 

[pbaldy]

I can't look at the sample right now, but does this help?

http://www.baldyweb.com/Autofill.htm

 

[SteveI]

It does sort of, thanks. But I still cannot seem to get the information that appears in the text box in the form to drop into the actual table. I have tried the following code as suggested, but it does not seem to work - or I am not sure where I am supposed to insert it...

Me.TextboxName = Me.ComboName.Column(2)

 

[pbaldy]

You would insert it in the after update event of the combo, and the textbox would need to be bound to the table.

 

[SteveI]

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 recipe/formula.

 

[SteveI]

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 ingredients as I go along i.e. formulate a paper formulation and then take it to the lab to manufacture (forms will take care of this). I am just struggling with the relationships and autofill.

The Formula table in my db is what I am trying to achieve from a surface level.

thank you for your help.