modify macro

[doyle9732]

I have inherited an Access database that we use to track our chemical lists. Actually, even the current Health and Safety coordinator has inherited it. A new chemical gets added in the database, and something (presumably a macro) copies the information to another table. But one of the columns does not get copied over. Not sure if it was originally named something else, but I have been everywhere in Access trying to find code that tells the system to write that information to the table - with no success. Does anyone have any idea what I'm talking about??

Any guidance would be most welcome....let me know if you need more information.

thanks!
Stephanie

 

[lespaul]

how does the new chemical get entered?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[doyle9732]

this is from the health and safety coordinator (who does the inputting)

Under Macros, there is a file called NEW CHEMICAL MACRO, that opens a file through which you can enter the information. Usually when I open the access from the desktop, this pops open and I never go through Macro to open it.

Stephanie

 

[lespaul]

who does the inputting

through a form? have you looked at the events on the form to see if one of them calls the macro?

 

[doyle9732]

Yes, through a form.

The form automatically opens first and when I go to the design mode --> properties --> events, I see nothing is written there (other than some default 'no's)

Stephanie

 

[lespaul]

Ok, you open the Access database and you are presented with a form that lets you add new chemicals to the database. The form has a place for the user to enter the chemical name and other information (what's the other information?). Once the information is completed the user does something (presses a button?) and the new record is saved to a table (what's the name of the table?). When the new record is saved to tableOne, some action takes places that adds a new record to some other table (what's the name of this table?). When the new record is added to TableTwo, some of the information is not added (what information is missing?)

What is the code/commands in the macro 'New Chemical'?