Combox uses 'wrong' value list

[Geirr]

Hi.

I've seen your video and again I've checked everything here, in special if I've made any typo errors in any references or choices.
The fun part I discovered late last night that for all three combo boxes, I can not use the 'build' option in the Row Source for the boxes, It's deactivated on all three for some reason...

I woold like to send you all the form with this issues, but it's a part of a rather big system with several of forms, navigation form, linked to a several tables in a sql server database. I don't want to spend too much time chasing ghosts, or waste your time, but thank you all for input.
I will remove the three combo boxes, copy the form to a dummy database, an import it back and start over with three combo boxes with query as row source type.

Best regards,
Geirr.

 

[isladogs]

Hi.

I've seen your video and again I've checked everything here, in special if I've made any typo errors in any references or choices.
The fun part I discovered late last night that for all three combo boxes, I can not use the 'build' option in the Row Source for the boxes, It's deactivated on all three for some reason...

I woold like to send you all the form with this issues, but it's a part of a rather big system with several of forms, navigation form, linked to a several tables in a sql server database. I don't want to spend too much time chasing ghosts, or waste your time, but thank you all for input.
I will remove the three combo boxes, copy the form to a dummy database, an import it back and start over with three combo boxes with query as row source type.

Best regards,
Geirr.

I understand why you don’t want to spend a lot of time on this or waste our time (thanks!) but, if there is a bug, providing a simple repro db will significantly assist with tracking it down. If I can reproduce this as a bug, I will forward it to the Access team

 

[Mike Krailo]

Did you read the explanation of what is happening behind the scenes?

No, I didn't see the explanation.

 

[isladogs]

The article mentioned in post#15 has a link to another article with the explanation