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 - 24 Mar 2008 20:27 GMT
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
tigerking - 25 Mar 2008 12:22 GMT
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:
>
[quoted text clipped - 11 lines]
>>
>> thanks