Does a combo effect the operation of a "Dupicate record" button.

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

Frank Martin

I have Access2000 with WindowsXP

On my address form based on QryAddresses we have a "duplicate-record" button
produced by the wizard, and this has been working well.
But when I added a "go to a record based on the combo selection" combo via
the combo wizard, the duplicate-record button does not work as before. It
duplicates the record in the underlying QryAddresses but in doing so shows
blank fields on the form.

Can some help me with this. There seem to be two types of combos; one type
with code behide it in the properties box, and another type without code.
Perhaps this might be a clue.

Regards Frank
 
Frank
Don't know if this well help, but maybe consider this

The combination box would certainly be effected by a duplicate record action. It sounds like you are duplicating a record within the same table. In an indexed table this record would require a unique index. Although you have duplicated a record the two records have a seperate internal bookmark. I am unsure, but it sounds as if you're saying that the combination box is turning up blank fields. This is important, because if after the duplication process your combo list is being wiped out, but a number of blank listitems are being added to the combo list = equal to the number of records in the bound table/query, then the problem is probably that the field settings for the combo box are incorrect. If no items have been added then
1. You may need to add code to the jist of clear, refresh, etc. for the combo box = placed under the dup command button
2. Check to make sure that your duplicate record has been created.
 
Yes, it's just as you say. The duplicate record is created in the
underlying table & query and blank fields are produced on the form. The
purpose of the "duplicate record" button is to add a customer's locationID
and in so doing produce a new record without retyping all the other
unchanged fields.
I'll try what you suggest. Regards


Jason said:
Frank,
Don't know if this well help, but maybe consider this:

The combination box would certainly be effected by a duplicate record
Click to expand...
action. It sounds like you are duplicating a record within the same table.
In an indexed table this record would require a unique index. Although you
have duplicated a record the two records have a seperate internal bookmark.
I am unsure, but it sounds as if you're saying that the combination box is
turning up blank fields. This is important, because if after the duplication
process your combo list is being wiped out, but a number of blank listitems
are being added to the combo list = equal to the number of records in the
bound table/query, then the problem is probably that the field settings for
the combo box are incorrect. If no items have been added then:
1. You may need to add code to the jist of clear, refresh, etc. for the
Click to expand...
combo box = placed under the dup command button.
 
Back
Top