Serious Help

[Rick]

I have a major bug in my database and I don't know how to
fix it, HELP!!!

Two part problem:

First, I need to eliminate duplicates in a query. (I used
the Unique Values and it didn't work. But the kicker is
this; I have one form (tblMember) with a subform
(qryAddApraisal-pulling from tblMember and tblApraisal) to
add a new appraisal for a member. I have a drop box to
select a member (pulling from the query) and I select the
member I want to update with a new appraisal.

Second, Problem here is for some reason, the member's last
name in the tblMember is changing to another name in the
table. Start with one individual named Johnson and end
with two individuals named Johnson?

Any help or additional information?

 

[John W. Vinson]

I have a drop box to
select a member (pulling from the query) and I select the
member I want to update with a new appraisal.

Second, Problem here is for some reason, the member's last
name in the tblMember is changing to another name in the
table. Start with one individual named Johnson and end
with two individuals named Johnson?

This will happen if you use a Bound combo box to select the record.

Combo boxes have two functions: 1) they can update the current record,
replacing the combo's Control Source field with the value in the
selected row's Bound Column; or 2) they can find another record using
VBA code to read the selected value and use it to navigate.

These two uses are pretty much incompatible!

Change the Control Source property of this combo box to a blank. Now
it won't overwrite the person's ID any more.

If you're using the last name as a key to this table... don't. You
very well might have two members who happen to have the same last name
(or even full name, for that matter).

 

[Rick]

OK, when I remove the control source, I can't pull/select
a record. I can use the navigation buttons at the bottom
of the form to go to the next record and cycle through
that way but it takes a long time to find the correct
record (total of 140 records). Am I missing something
here?

 

[John W. Vinson]

OK, when I remove the control source, I can't pull/select
a record. I can use the navigation buttons at the bottom
of the form to go to the next record and cycle through
that way but it takes a long time to find the correct
record (total of 140 records). Am I missing something
here?

Evidently!

How did you create the Combo Box? Does it have VBA code in its
AfterUpdate event (look at the properties of the combo; it should show
[Event Procedure] on the After Update line on the event tab).

You may want to delete the combo altogether and start over; use the
toolbox Wizard and choose the option "I want this combo to find a
record on the form". If the wizard is uncooperative post back, it's
not hard to write the code.