Enter data on form without changing records

[darkmage1]

I have a form that is used as my search form. This form is referenced to a query. I would like to be able to enter data on the form but not to have any records changed. The problem is that when I enter data on a form the records get changed. I want the form to be a search form with no record alteration ability. I am not sure how to do this. The form seaches for records correctly but it also changes data also.

 

[ProgramError]

You need to unbound the form and insert the query data results in each control. Then, if you change any of the data on the form it will not change the data in any tables.


Ian Mayor (UK)
Program Error
Programming is 10% coding and 90% error checking.

 

[RoyVidar]

While it is hard to say something based on the information, if you change the AllowEdits property of the form to no, you should be able to add new records, but not change existing ones.

Roy-Vidar