Table Writes to another Table

[kylepanek]

I cannot figure this out.... I am very new to Access.

I want a table to write to a record another table if a check box is checked.

I attached the copy!!

When I enter a transfer and check CID or Good I want it to write all that information to Good RA parts table

 

[John Big Booty]

Sorry couldn't open your DB.

However one way to achieve what you are after would be to create an append query, that could append any record/s in your first table that are checked to your second table. You would also need an update query to set the check to unchecked once the append query had been run.

 

[Starman]

I didn't attempt to open your db, but are you doing this through a form? A form would make it a lot easier to do this as you could put the code to run your append query in the After Update event (or where ever you want it) of the checkbox on the form.

 

[boblarson]

I did take a look at your database and a few things jump out at me:

1. You are using lookups at table level (a big no, no - see here for more on that: http://www.mvps.org/access/lookupfields.htm )

2. As mentioned by Starman, you really need to use FORMS for data entry as they give you more control over things. You and/or users should not be entering data directly in tables or queries. Forms give you EVENTS which allow you to validate entries, make other things happen based on the entry given, etc.

3. Don't use special characters, or spaces, in object names (nor field names). Your use of the # sign is one example. The octothorp (#) has special meaning to Access as it is a date delimiter. Here's a list of reserved words to avoid as just an FYI as well:
http://www.allenbrowne.com/AppIssueBadWord.html

4. You should also look into NORMALIZATION as you are currently storing redundant data (for example storing the description of something instead of its Primary Key).

See here for more about that:
http://www.accessmvp.com/strive4peace/Access_Basics_Crystal_080113_Chapter_03.pdf
http://support.microsoft.com/kb/283878