Find data

[aaromic2000]

Hi,

I've earlier posted on the same request but, I'm quite unsuccessful in getting that yet.

I have a unbounded form which has all the fields same as the table. Now I want to search a row from the table with the Ticket number and First Name. After retrieving all the fields instead of using Update query I just want to add it as a new record. Can anyone help me please?

 

[CJ_London]

the detail you have provided is a bit vague which is probably why you have not received a response previously.

It sounds like you need a 'save' button on the form which executes an insert query. Or you could make the form bound and set to data entry only.

If this does not answer your question sufficiently, suggest you explain in more detail how you are populating the form - provide the code which does this. Having populated the form, what does the user do? make changes to the values or completes blank controls?