| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Write to Table from a Form
I have a form called ChemicalInput that takes chemical names in a Name field
and manufacturers in a Manuf field. I want to write the first letter entered in the Name field back to the Chemicals table in a field called NameCode. The NameCode field is present in both the Chemicals table and the ChemicalInput form. I am using the following as the control source (in the Text Box Properties) for the NameCode field in the form: =left([Name], 1) It populates the first letter of the Name field into the NameCode field just fine. How can I get the data in the NameCode field to write back to the Chemicals table? Thank you in advance. -- Markb |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I write a function that automatically changes over time | Excel Worksheet Functions | |||
| why do some cells automatically switch to ####### when I write? | New Users to Excel | |||
| Write data to Access table with INSERT when table has auto number | Excel Programming | |||
| help me write this table retaining table spacing and formatting | Excel Programming | |||
| is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
Hybrid Mode
