By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,325 Members | 1,179 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,325 IT Pros & Developers. It's quick & easy.

record is not moving to next record on the dropdownlist

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a
Have you bothered to read your replies?

Phil
"Doslil" <do****@hotmail.com> wrote in message
news:c6**************************@posting.google.c om...
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

Nov 12 '05 #2

P: n/a
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.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.