append queries

[S.Dickson]

i have this append query its working apart from one bit

for the field Manufacure ID, I would like it to get the number from the
form i am on
How do i get it set up in the query that when it appends all the data
to the new table is also puts ManufactureID number next to all the
recores



[Forms]![frmManufactureTub]![ManufacuterID]

 

[kingston via AccessMonster.com]

Use a calculated field in the query where the entry for Field: is [Forms]!
[frmManufactureTub]![ManufacuterID]
Access will probably give it a name like Expr1:
Then select the proper field in the Append To: section.

If you want to do something more, you can use a string function or math:
"Something " & [Forms]![frmManufactureTub]![ManufacuterID]
[Forms]![frmManufactureTub]![ManufacuterID]*10

i have this append query its working apart from one bit

for the field Manufacure ID, I would like it to get the number from the
form i am on
How do i get it set up in the query that when it appends all the data
to the new table is also puts ManufactureID number next to all the
recores

[Forms]![frmManufactureTub]![ManufacuterID]