Trouble with form

[tom.hansen]

I have been using a database designed to track grievances at a health care facility. The db consists of, amongst others, a table containing resident records, a table containing staff records, and a table with grievance records. I have created a grienvance record form with combo boxes for staff and residents involved. The relationships linking the staff and resident tables to the grienvance table are many to many. The resident or staff member's names are set as the primary keys in their respective tables. I have the pk set up this way because the pk is displayed on a form I use on my palm. Although I work at a long term care facility, there is a high turnover of residents and staff. When I enter a name that is not in already in the db, I am alerted that the record does not exist and am prompted to select a name from the list. For the past year or so, I have accepted that I need to open a sepate form to create a new record for the new resident or staff. I would like Access to recognize that the new name does not match a record in the db and create a new record.

What changes do I need to make to allow entry of a new name in the form that will create a new record in that respective table?

 

[Jack Cowley]

If you are selecting the resident from a combo box then you can use the combo boxes Not In List event to do what you want. This article will show you two methods of adding a new resident to the table.

hth,
Jack