13. marts 2003 - 15:20Der er
8 kommentarer og 1 løsning
Kan ikke vælge værdi i kombinationsboks
Jeg kan se de rigtige værdier i min kombinationsboks men har ikke mulighed for at vælge dem. Hvilke grunde kan der være til det???? Formularen hvor dette bruges er baseret på en forespørgsel men kombinationsboksen er baseret på en tabel. Kan dette have noget med sagen at gøre. Har også prøvet at lave kombiboksen på forespørgslen men det virker ikke. Jeg kan ikke vælge noget!! Forslag???
Efter ti år i London, Madrid, Paris og Utrecht kommer Sabios AI-fokuserede program af arrangementer om kundeoplevelser, ‘Disrupt’, for første gang til Danmark.
If the query is NOT updatable then you can not change the underlaying record if the combo is bound to one of the fields. Can you change any other fields on the form?
If there is more than one table in the query then there is a good chanced that you will not be allowed to update the data in the form and that is why you can not choose from the combo as this will change that data.
You are right! I can't add a record in the query. I've checked my relations and as far as I can see they are all right. one-to-many. what can be wrong??
you should NOT have a one to many relationship in the query this is the reason why you can NOT update. You need to have a main form with a sub form. The main form is for creating a single record on the one side of the relationship and the sub form is for creating records on the many side of the relationship. Try using the form wizard for creating the forms. Add both tables NOT the query!
Well...the problem isn't solved yet...but I think there is an initial fault in the design of database...so it goes deeper...we're trying to go through it all now...hard when I didn't do it myself...but you helped me a great deal along the way so VOILA! 60 points...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.
