Use of table data when filling out forms

[Guest]

Hello, newbie using Acess 2000.

I've created a form to enter and track sw issues. Values that are often used I have set-up in different tables. For example -tblBusinessUnit, which has listed 15 business units. This list is not all-exclusive, so the user may need to enter a BU that is not in the list (I would then want it added).

When the user enters data in a new blank form, why is it that when he/she types in a name that already exists in the tblBusinessUnit table, it adds it to the bottom of the table with a new ID? I would like it to point to the existing BU name instead of adding a new entry. How do I do this

Thank you for your help
-r

 

[Adrian Jansen]

You have to set up a routine which allows the form to try a search for the
new name, and then add the name if it is not found, or go to the entry if it
is found. And handle the case where the user mistyped a name and just wants
to cancel the entry. A combo box built with the wizard set to "find a record
in the form, based on my selection" will do most of this, coupled with the
combo box Not-in-list event.

If you do a Google search within this newsgroup for subject headers
including the phrase "not in list" you will find plenty of discussion on how
to do this.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

Hello, newbie using Acess 2000.

I've created a form to enter and track sw issues. Values that are often

used I have set-up in different tables. For example -tblBusinessUnit, which
has listed 15 business units. This list is not all-exclusive, so the user
may need to enter a BU that is not in the list (I would then want it added).

When the user enters data in a new blank form, why is it that when he/she

types in a name that already exists in the tblBusinessUnit table, it adds it
to the bottom of the table with a new ID? I would like it to point to the
existing BU name instead of adding a new entry. How do I do this?