cann't save data to table

T

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 can i save the other data in that table?

thanks
 
Top