Hi Jonny. See if this old article on using the Lookup tab helps explain some things.By field raw source I mean to SQL code to populate the combobox (or any other control).
Sorry If my question sounds stupid.. but..
When I build a form I bound all fields to various tables, where comboboxes are populated from tables and table are updated from text fields.
In that way I've managed to create a project without creating relationships between tables.
Therefore I do not really understand the purpose of table relationships?
However using referential integrity + Combo Box Wizard looks as the right combination to do that.The value you entered is not valid for this field access form combobox
SELECT [Departments].[ID], [Departments].[Dept] FROM Departments ORDER BY [Dept];
That's because the Wizard asks you if you want to "hide" the ID column.Something weird happens ..
Same raw source using combo box wizard shows readable data and regular look-up shows ID?!
So why when I'm hiding it without the wizard I'm getting an error?That's because the Wizard asks you if you want to "hide" the ID column.
Hi. You'll have to show us exactly what you did before we can have an idea of the "why." Are you able to post a screenshot or sample db?So why when I'm hiding it without the wizard I'm getting an error?
Hi. Thanks for posting a sample, it helps understand the problem a lot. I can see two problems with your first combobox.Posted,
I've added both combos on the form, one is working while the second is not.
What's wrong with the first?
Thank you
Hi. Thanks for posting a sample, it helps understand the problem a lot. I can see two problems with your first combobox.
1. The Row Source is different from the second combobox, and
2. The Column Count and Column Widths are also different
Another problem I see with your database is you're using a Lookup field in the Employee table for the Department. This is adding to the confusion.
Hi. You're welcome. We're all happy to assist. Good luck with your project.Eureka,
The main problem in all my combos was "not-applying" 0cm width for a first column!!
Thanks so much!