append queries

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]

Create a Calculated field in your query:
MfgID = [Forms]![frmManufactureTub]![ManufacuterID]
Then put the field you want the value in in the Append To: row for this field.

" wrote:

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]

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


wrote:
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]

--
Message posted via http://www.accessmonster.com