Record Find 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.

 

[fullkeel]

If I understand (and I am really confused), a real simple solution would be to add a subform to your searching form, the subform would call up the same table as the main form but only allow for adding new records. In other words you would not be setting them up as Parent and Child, you would be just giving the user a place to look and a separate place to add new data. The same could be done with two separate forms on the screen but that has a way of getting mesy at times.

Bruce Gregory