SetValue Macro

[Con Giacomini]

My form enters work order data into a Work Order table. This data includes
delivery information that must be entered into a Delivery table.
A command button on the data entry form sets the required delivery data into
the Delivery table using a SetValue macro. The macro works correctly, but
each new field that is added replaces the prior value in the Delivery table,
leaving only a single record in the table.
Any advice would be appreciated.

 

[Guest]

Hi,

I am not sure if this would sloev your problem might that you have to add a
statement like addnew or something to add a new row, I am not sure. In case
you post the code it could be more useful to debug it.
But in any case just check if a add nre cord statemtn or something needs to
be added to the macro.

Anand

 

[Steve Schapel]

Con,

It is hard to say specifically without knowing more about your table and
form structure/design. But I would certainly not be using a SetValue
action for this purpose. I would suggest an Append Query or an Update
Query (based on your information I guess an Append Query would be the
one) to write the required data to the Delivery table, and then an
OpenQuery action in your macro if you need to auttomate the append. But
I also suspect that the need to do this could probably be eliminated
with a design change of your table and/or forms.