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

[Merlin]

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.

Thanks.
Merlin

[Cor]

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
instance)

Cor

[Merlin]

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 @ http://www.forecourtsupport.co.uk/App1.zip and can
be download for people to see

Thanks
Merlin

"Cor" <no*@non.com> wrote in message
news:Oy*************@TK2MSFTNGP10.phx.gbl...

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
instance)

Cor

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004

[Cor]

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).

Cor

[Cor]

Hi Merlin,

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

Cor