Link combobox in form to a particular cell in table

[epardo87]

Hello all,

So I have this form "Supervisor Desig", where I placed three times the combobox for the "supervisor" column in the table "tblArea". I know that I could just embed the table in a form or put a combobox for the "area" column as well. but I'm designing this platform to be as friendy-user as possible. so I would like that the name selected in the first combobox updates only the row corresponding to "Grupo A" and so on...

I'd really appreciate your help, thanks!

[ranman256]

Forms only work 2 ways:
a single record form (shown?) that shows 3 fields
or
a continuous form,to show All records

which is yours?

[ssanfu]

Change:
Grupo A combo box
Row Source: SELECT Supervisor FROM tblAreas WHERE Area = "Grupo A"

Grupo B combo box
Row Source: SELECT Supervisor FROM tblAreas WHERE Area = "Grupo B"

Grupo C combo box
Row Source: SELECT Supervisor FROM tblAreas WHERE Area = "Grupo C"


If there are many people on Grupo A they will show up only in the one combo box.

[epardo87]

thank you ranman256, I had seen about these two types of forms but completely forgotten about it. the continuous form is what I was looking for, now I just have one more question.
When selecting the continuous form, I have three records, but it shows me a fourth one, the new record option, but I don't want to display that, i tried to erase it from design and layout views but wont let me, how can I avoid it from being displayed?

[epardo87]

Change:
Grupo A combo box
Row Source: SELECT Supervisor FROM tblAreas WHERE Area = "Grupo A"

Grupo B combo box
Row Source: SELECT Supervisor FROM tblAreas WHERE Area = "Grupo B"

Grupo C combo box
Row Source: SELECT Supervisor FROM tblAreas WHERE Area = "Grupo C"


If there are many people on Grupo A they will show up only in the one combo box.

thanks ssanfu, actually, the column "supervisor" is pulled from a query, so im writing the code like the following, but i'm getting a Syntax error... what am I doing wrong?

Private Sub Combo0_Change()


Combo0.RowSource SELECT supervisor FROM tblAreas WHERE Area = "Grupo A"


End Sub

[aytee111]

Allow Additions - that is the form's property that you need to set to No.

[epardo87]

Great! thanks aytee111

[ssanfu]

thanks ssanfu, actually, the column "supervisor" is pulled from a query, so im writing the code like the following, but i'm getting a Syntax error... what am I doing wrong?

You DON"T use the combo box change event to set the combo box row source!

Your image in Post #1 was a form in Single Form view. Now it appears that you are using continuous form view.
What is the SQL of the query?


I would rename the combo box for the area "cboArea". I would set the combo box Row Source property to something like

SELECT DISTINCT Area FROM tblAreas ORDER BY Area

The combo box for the supervisor I would name "cboSupervisor". I would set the combo box Row Source property to something like

SELECT Supervisor FROM tblAreas WHERE Area = '" & me.cboArea & "'"

Would need to see the dB to give a better answer...........