Pull Value from one table and deposit in another

A

Annemarie

Hello!

I have been trying to pull a value from one table (ex [Lookup
Table].[NTG]) on a form and have that value be a baseline. I would
like this number to store in a field in another table (ex
[Subfunctions].[NTG]) this way the user can change the value if needed
for a specific record and not change the pre-set "library" value. I
have tried using [Lookup Table].[NTG] as the Default, and
[Subfunctions].[NTG] as the control source but the number will not pull
in. The form is based on a query that includes both values, so i have
tried to filter the form and have the value pull into the the
[Subfunctions].[NTG] from either that forms' [Lookup Table].[NTG] or a
previous forms' [Lookup Table].[NTG] ...previous form based on same
query. I am not having any luck. I have the form filtered based on
another field value already. The reason I have to have the second form
is to enter additional data based on the first form...but there are two
different forms asking for different data that pop up based on the
value in a field on the first form. How do I pull this value from one
table and store it in another?? Please help..I am going crazy!
 
Top