forma change problem

[GS]

I added column machine to table issue and another table machine to an access
database
when I tried add the machine column as combo box I can find the control
source for machine. resulting in unbound control box.
I tried save the table, close the mdb with save and reopen but no avail.


what did I miss?
I rarely use access

 

[Bob Quintal]

I added column machine to table issue and another table machine to
an access database
when I tried add the machine column as combo box I can find the
control source for machine. resulting in unbound control box.
I tried save the table, close the mdb with save and reopen but no
avail.


what did I miss?
I rarely use access

Form with Combobox is based on query. Query based on table.
add field to query.

 

[GS]

I found the culprit.
the form is not using the table but query, so I change the query and then
modify the form. I guess that is a hazard with work on someone else creation
wi/o the benefit of documentation

I was also able use the tool- database util to split the tables into a
separate backend db and create mde for use to use.