do****@hotmail.com (Doslil) wrote in message news:<c6**************************@posting.google. com>...
hi,
I have a drop down list on the main form which has a query attached to
it.Looks like the record is not moving to the next record,cos when I
select the next record from the list it gives an error message "the
record could not saved ,it could create a duplicate values in the
index,primary key or relationship............".I am also getting this
message when I click on the record selectors.
Can anyone please give me any tips
Sounds like your combobox is bound, and it shouldn't be. The standard
way to do this is to build your form, and then drop a combobox on the
form. A wizard should start, and you want to select "find a
record..." (or whatever) that you specify in the combobox. Then the
code just applies a filter to your form based on the combobox. the
reason you're getting the "save" stuff is that you're changing values
in your form, so the form is dirty, so Access is trying to save your
record when you do this.