Combo box form not updating required table

[soklear]

Hi. Newbie Bob here again.

I have a combo box form that the user is supposed to choose a part name from and it populates all three subsequent txt boxes with price, quantity and time to ship after the part name is chosen.

I have two tables, one is the 'primary' table with all the information (part name, quantity and time to ship). The other is supposed to be the table the form is saved to. I cannot get the information the user selects on the form to save to the order information table.

I would like to be able to update the order information table with information from the form that is pulling form the query I am using is pulling information from the 'primary' table.

Is there a way to insert the updates to the order information table (ordrinfo) while still keeping the 'table' as the record source for my form?

Please let me know if you need more info.

Thanks,
Bob

 

[Remou]

The best bet would be an Update or Append query. You could run it from a save button or from a suitable event.