Hello! I'm relatively a newbie in access 2007, but i had my way around sql years ago, and sometimes i do some developing.
Now, for a project, i was asked to program an access 2007 database with some forms that display data. It was an interesting
challenge, because access handles things differently...
Anyway, i've solved several problems with the help of several forums, but now i have a new one:
I have a form that has 3 comboboxes, each one triggering a query onafterUpdate:
Private Sub combo_proyecto_AfterUpdate()
Me.combo_sitio.RowSourceType = "Table/Query"
Me.combo_sitio.RowSource = "ask_idsitio"
Private Sub combo_sitio_AfterUpdate()
Me.combo_panel.RowSourceType = "Table/Query"
Me.combo_panel.RowSource = "ask_quepaneles"
the first combobx selects a project; that feeds the second combobox with the different sites on that project (a query inside
this combobox takes a value from the previous combobox: id and name) and that feeds another combobox with items that are on
that category (with another query, as well). It works pretty good! but now i want to populate several textboxes with the
result of the last triggered query; so, the query inside this last combobx is more extense than the queries inside the
previous comboboxes, and I populate the textboxes like so:
Private Sub combo_panel_AfterUpdate()
Me.uno = Me.combo_panel.Column(0)
Me.dos = Me.combo_panel.Column(1)
Me.descripcion = Me.combo_panel.Column(2)
Me.tres = Me.combo_panel.Column(3)
Me.cuatro = Me.combo_panel.Column(4)
Me.cinco = Me.combo_panel.Column(5)
Me.seis = Me.combo_panel.Column(6)
Me.siete = Me.combo_panel.Column(7)
works relatively good, but here comes the trouble: it only displays the results to the column 2, and the rest is all blank.
If i run the query alone, it works perfectly, displaying all results, but for some extrange reason it doesnt run good within
the form. Here's the query:
SELECT DISTINCT tabla_muestra.panel, tabla_muestra.[codigo muestra], tabla_muestra.[descripción de la figura],
tabla_muestra.ruta_imagen, tabla_muestra.color, tabla_muestra.[codigo color], tabla_muestra.id, tabla_muestra.[adscripción
FROM tabla_muestra, tabla_relacion_sitios
ORDER BY tabla_muestra.id;
what could it be?
thanks in advance... i hope my explanation is clear... :s