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

Data Relations and i`ll even pay someone now to tell me!

P: n/a
Hey All,

I`ll Pay someone to tell me this now, as its doing my head in, I carn`t see
out on the net and no one seems to know!

I have a form that connects to a Access database, and I have a combo box on
this form (this combo box has a list of Access Levels, a user would be
able to choose one Access Level out of the combo box).

The combo box is serving double duty, as they usually do, it is giving me a
list of all of the Access Levels in a drop down, and it is also returning
the Access Level of the record that I am retrieving from my Access Database.

Everything works perfectly, but. . .

When I navigate through my records, the combo box (Access Level) does not
change with what the Access Level should be for that particular record, it's
almost like it sticks on the same Access Level. The AccessLevelID
(different text box) changes with every record but the combo box doesn't.

I did some troubleshooting. . .

If I put a text box in place of the combo box it works correctly, but this
does not solve the problem of the user being able to select a Access Level,
hence the need for a combo box.
I`ver tryed to explain this before but unforutnatle i don`t think im
explaining properly, i have a example project that I could e-mail if anybody
could offer me some help?

Any links as I don`t mind reading

Please help.


Nov 20 '05 #1
Share this Question
Share on Google+
4 Replies

P: n/a
Hi Merlin,

Because you get no answers, show us some code as sample, not all just to
inform us what you try to archieve. (How do you build the relations by

Nov 20 '05 #2

P: n/a
Hey Cor,

Thats what I have trouble in explaining, I cannot imagine me going throught
the whole procedure, and if I give screen shoots and that would make people
unhappy as there big.

My Project is located @ and can
be download for people to see


"Cor" <no*> wrote in message
Hi Merlin,

Because you get no answers, show us some code as sample, not all just to
inform us what you try to archieve. (How do you build the relations by


Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004
Nov 20 '05 #3

P: n/a
Hi Merlin,

I have looked at your problem, I saw one thing that is strange in my eyes,
there is a relation in the XSD from your Access Id to the UserID, should
that not be to the AcceslevelID from the user.

And you did not do it in a simple (but I think not a wrong) way. I will not
change your code totaly but take your approach to try to help you.

A problem for me is that you have used all wizards as possible as far as I
can see. When this is not the problem, maybe you can than make a sample mdb
file with 2 accesscodes and 2 users in the way that you made it and add that
to your zipfile.

(It has to be today, tomorrow I have absolute no time for this or else it
will be friday).

Nov 20 '05 #4

P: n/a
Hi Merlin,

I think I found your problem, the answer is in the adonet group.

Nov 20 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.