bypass the error messages?

[jayme]

ms access 2000.
on my default switchboard there is a button that opens up a form(named Inquiry Find). on the form you can type in an "Inquiry Number" then click the button to look up that certain number and all the information that goes with it-which is on another form (named JOB TRACKING form). so it automatically brings up that record in the JOB TRACKING form. i have this set up so people can easily find the inquiry number they are looking for then edit the information.
well i was testing this out-so i opened up an inquiry number, made a change to it and when i hit the [>*] to save and then close the forms it comes up with an error saying that the changes were not successful becuase it would create duplicate values. so i hit ok then it says that it couldn't save the changes at this time. do you want to close the db object anyway? and i choose yes.
WELL-when i go back into the table and look at that record the changes are there!
so im confused why i am getting this error. its not a big deal but other users will be using this db so is there a way to just bypass the erros so they don't think something went wrong?

thank you!

[MMcCarthy]

ms access 2000.
on my default switchboard there is a button that opens up a form(named Inquiry Find). on the form you can type in an "Inquiry Number" then click the button to look up that certain number and all the information that goes with it-which is on another form (named JOB TRACKING form). so it automatically brings up that record in the JOB TRACKING form. i have this set up so people can easily find the inquiry number they are looking for then edit the information.
well i was testing this out-so i opened up an inquiry number, made a change to it and when i hit the [>*] to save and then close the forms it comes up with an error saying that the changes were not successful becuase it would create duplicate values. so i hit ok then it says that it couldn't save the changes at this time. do you want to close the db object anyway? and i choose yes.
WELL-when i go back into the table and look at that record the changes are there!
so im confused why i am getting this error. its not a big deal but other users will be using this db so is there a way to just bypass the erros so they don't think something went wrong?

thank you!

Check out the JOB TRACKING form. It sounds like you are trying to add a record as well as save changes. Check out the code in the forms close and unload events.

[jayme]

i looked at the events on the JOB TRACKING form and there are no close or unload events. so is that the problem? what needs to be in those events to make it work correctly?

[MMcCarthy]

i looked at the events on the JOB TRACKING form and there are no close or unload events. so is that the problem? what needs to be in those events to make it work correctly?

No I thought there was something there that was causing the problem.

What is the query that is the record source of this form?

[jayme]

What is the query that is the record source of this form?

the record source of both forms is a table-when you fill out the [JOB TRACKING form] it updates the table. so for the [Inquiry Find] form it finds the requested inquiry number that is entered, in the table then pulls up the form for that record with all the information for that number.
does that make sense?

[MMcCarthy]

the record source of both forms is a table-when you fill out the [JOB TRACKING form] it updates the table. so for the [Inquiry Find] form it finds the requested inquiry number that is entered, in the table then pulls up the form for that record with all the information for that number.
does that make sense?

Are you saying that the Inquiry Form is bound to the table? If so, why?

[jayme]

Are you saying that the Inquiry Form is bound to the table? If so, why?

i made the [JOB TRACKING form] to fill in the [JOB TRACKING] table - it is an easier and more organized way of filling in what needs entered into the table. then i got the idea of being able to just type in the inquiry number you need and that form that has been previously filled out comes up and you can edit it or whatever you need to do to it. so thats when i made the [Inquiry Find] form as like a preface to the actual [JOB TRACKING form]-it is just supposed to find the number we need and pull that form up.

[MMcCarthy]

i made the [JOB TRACKING form] to fill in the [JOB TRACKING] table - it is an easier and more organized way of filling in what needs entered into the table. then i got the idea of being able to just type in the inquiry number you need and that form that has been previously filled out comes up and you can edit it or whatever you need to do to it. so thats when i made the [Inquiry Find] form as like a preface to the actual [JOB TRACKING form]-it is just supposed to find the number we need and pull that form up.

But you don't need the Inquiry Form bound to the table. Just a listbox or combobox bound to a query that has the required fields. You are then opening the JOB TRACKING form to the selected record in the listbox/combobox. By having both forms open to the same record at the same time Access is trying to compensate by creating a new version of the record.

Mary

[Denburt]

If you go directly to the table and you make the same changes directly in the table do you have the same problem?

[Denburt]

Mary definitely sounds like she has the issue nailed down (sorry Mary). ;)

[MMcCarthy]

Mary definitely sounds like she has the issue nailed down (sorry Mary). ;)

No apologies necessary. Nice to have extra input even if only to confirm my own feelings about what is going on. :)

Mary

[jayme]

If you go directly to the table and you make the same changes directly in the table do you have the same problem?

no it allows me to make changes in the table and close it without any problem. i think it might be what mary said

By having both forms open to the same record at the same time Access is trying to compensate by creating a new version of the record.

so the best way to do this would be to create a listbox or combobox you think?

[jayme]

Mary definitely sounds like she has the issue nailed down (sorry Mary). ;)

well thanks for your help too denburt!

[MMcCarthy]

so the best way to do this would be to create a listbox or combobox you think?

Yes.

The Inquiry form should not be bound to the table and should just have a listbox/combobox with enough column data to allow the user to select the appropriate record.

Mary

[jayme]

Yes.

The Inquiry form should not be bound to the table and should just have a listbox/combobox with enough column data to allow the user to select the appropriate record.

Mary

ok-i understand. thank you.
is there a way for them to just type in the number they want? just to make it easier..becuase there are TONS of records to scroll thru-so if theres a way for them to type the number then hit enter or whatever that would be much easier.

[jayme]

i think that i got it to work by using a command button..i have a combo box where they type in the number they want then they push the command button that opens the form with all the information on it.
i tested it and made changed then closed the forms and did not receive any errors..so i think it works!
thanks for your help!!!!

[MMcCarthy]

i think that i got it to work by using a command button..i have a combo box where they type in the number they want then they push the command button that opens the form with all the information on it.
i tested it and made changed then closed the forms and did not receive any errors..so i think it works!
thanks for your help!!!!

You're welcome.