cann't save data to table

[tigerking]

I am doing a parts list inventory . so I have a form named View_all_parts
that show the whole parts in Continuous Forms, and I have a command button at
the end of each record that open invoice_form and retrieve some data for a
specific record ,
invoice_form have these fields:
customerID "autonumber"
part_number "from Countinuous Form"-"using =Forms!View_all_parts.Form!
part_number"
part_name "from Countinuous Form"-"using =Forms!View_all_parts.Form!
part_name"
price "from Countinuous Form"-"using =Forms!View_all_parts.Form!
price"
quantity "I have to put the number"

everything works fine except I can not save them to another table, only the
customerID and quantity have been saved.

so how can i save the other data in that table?

thanks

 

[Nicholas Scarpinato]

This syntax:

Forms!View_all_parts.Form!part_number

is wrong. It should be:

Forms!View_all_parts.part_number


That should solve your issue.

 

[tigerking via AccessMonster.com]

thanks Nicholas, I have change the syntax you wrote but still the same
problem, I can not save the data field that come from View_all_parts only the
field I fill have saved.

This syntax:

Forms!View_all_parts.Form!part_number

is wrong. It should be:

Forms!View_all_parts.part_number

That should solve your issue.

I am doing a parts list inventory . so I have a form named View_all_parts
that show the whole parts in Continuous Forms, and I have a command button at

[quoted text clipped - 16 lines]

thanks