A
AllyB
Hello,
I have a database to track customer complaints, with two forms, and two
tables. One form is for data entry and one form is for updates. For the
tables, I have an initial entry table, and an updated entry table which links
to the initial entry table on complaint id (a one to many from initial to
update). On the update form I use cascading combo boxes to allow the reps to
pick which complaint they want to update. They do this by picking last name,
then based on that the first name combo box choices are populated, and then
based on the two, the complaint name combo box choices are populated. But,
the form opens up with data in the fields already, and when I change the
surname from what is pre-populated, the underlying record in the original
entry table gets changed. For example, when I open the form, the surname of
Michaels shows up, with a first name of Margaret and a complaint of "Too long
to wait" (this, btw, is the first record in the data entry table). If I
change the surname to Lewis, then the record in the table now shows Margaret
Lewis with a complaint of "Too long to wait". I think this is all somehow
related, but I'm struggling to figure out the following:
First, I want the form completely blank when I choose the update option from
the main switchboard. Right now, it's populated with information already.
This leads to the second problem.
Since the update form opens with fields already populated (for example,
Margaret Michaels as the first/last name combo), when I want try to pick a
different surname, I click on the drop down arrow, and pick the surname I'm
looking for (e.g. Lewis). BUT that causes the underlying record in the table
to now show Margaret Lewis, not Margaret Michaels. I just want these fields
that the user uses to choose a record to update to be display.
I've tried changing form, detail and control properties and cannot seem to
find what the magic mix is. Any help anyone can give is much appreciated.
I have a database to track customer complaints, with two forms, and two
tables. One form is for data entry and one form is for updates. For the
tables, I have an initial entry table, and an updated entry table which links
to the initial entry table on complaint id (a one to many from initial to
update). On the update form I use cascading combo boxes to allow the reps to
pick which complaint they want to update. They do this by picking last name,
then based on that the first name combo box choices are populated, and then
based on the two, the complaint name combo box choices are populated. But,
the form opens up with data in the fields already, and when I change the
surname from what is pre-populated, the underlying record in the original
entry table gets changed. For example, when I open the form, the surname of
Michaels shows up, with a first name of Margaret and a complaint of "Too long
to wait" (this, btw, is the first record in the data entry table). If I
change the surname to Lewis, then the record in the table now shows Margaret
Lewis with a complaint of "Too long to wait". I think this is all somehow
related, but I'm struggling to figure out the following:
First, I want the form completely blank when I choose the update option from
the main switchboard. Right now, it's populated with information already.
This leads to the second problem.
Since the update form opens with fields already populated (for example,
Margaret Michaels as the first/last name combo), when I want try to pick a
different surname, I click on the drop down arrow, and pick the surname I'm
looking for (e.g. Lewis). BUT that causes the underlying record in the table
to now show Margaret Lewis, not Margaret Michaels. I just want these fields
that the user uses to choose a record to update to be display.
I've tried changing form, detail and control properties and cannot seem to
find what the magic mix is. Any help anyone can give is much appreciated.