Viewing duplicate entry

[puppydogbuddy]

Ashenton,
The attached revision of your db includes the following modifications:
1. DAMS table-changed "required" to not required (model,status,e tc). Requiring them in table for additions also makes them required for inquiries and edits. Generally, enforcement of required fields is handled thru form edit code via the fields before update event.
2. DAMS Stock Edit form- added an unbound search field; eliminated existing code related to old search field because you were using bound field which would change the table. Locking the old field interfered with Editing. Added new code routines for AfterUpdate, Current events

Test it out and let me know.

[ashenton]

That's good :)

Is there some way of having the DAMS Number Search field built in to the DAMS Number field?

What I'd like to have it do is if you create a new record but the DAMS Number already exists, the DAMS Number field does the job of the DAMS Number search field and tells you it already exists before it takes you to the matching record.

If it doesn't exist, I'd like it to let you enter the new information without it telling you it doesn't exist.

I'm a bit demanding I know, but I need to keep it as user friendly and totally idiot proof as possible...! lol

[puppydogbuddy]

Ok, will take a look asap and get back to you by tomorrow.

[ashenton]

Thank you very much :)

[puppydogbuddy]

Try the attached revision. In order to make this work the way you want I had to create a toggle switch effect (switching properties and values between the DAMS_Number control and an unblound textbox.

[ashenton]

Hi,

Thanks for that, it's great.

There is something I'd like it to do slightly differently...

When you create a new entry, it goes to a form with no records. Once you have created the new entry you have to exit and then re-open the form to view the existing entries. Is there a way of getting it to just continue at the end of the records as if there was no code at all?

I'd also like it to tell you that a record already exists before it takes you to it and not have it ask you if you'd like to create a new one where none exists.

Does that make any sense? lol

[puppydogbuddy]

The attachment should take care of your latest request. If you have any other requests for modifications, you should open a new post.