Find Record and Append Data

[JRA]

Hi,

I'm trying to set up a button on my form that will find specific data, but will leave one field blank so that the user can add new data and rather than replacing the old data , will then be appended as a new row in the table.

I'm kind of desperate and need to get this project done very quickly, so any help would really be appreciated.

Thanks,
James.

 

[Bastien]

You need to think about the Db structure here. How many times are you going to let the user add new data before overwriting the old data? If never then you need to create a new table that holds just the data with some kind of ID to link the tables holding the basic info and the added data.
One easy way to do this is using a SUB FORM to add the data to the new table. You can set all the links and display the subforms data (all records about that client, product whatever) when the main form shows the basic data about the item.
hth Bastien

There are many ways to skin this cat,
but it still tastes like chicken