fields are not sychronized in form

I put a combo box in my form, so that i can click on names. The combo box is
based off of a query from a table. As I change the combo box (names), instead
of all the fields in the form updating to the new record, it is just changing
the current record's field name. I am unsure how to connect the other records
to that combo box? I also want to have another combo box so that i can narrow
my search even further, is this possible?

The combo box should be unbound.
The recordsource should be filtered by the value of the combo

Select * From TableName Where NameField Like nz(Forms![ComboNameInForm],"*")

Or if you using two combo's
Select * From TableName Where NameField Like nz(Forms![ComboNameInForm],"*")
And NameField2 Like nz(Forms![Combo2NameInForm],"*")

On the after update event of the combo. write the code me.requery

"JJ" wrote:

I put a combo box in my form, so that i can click on names. The combo box is
based off of a query from a table. As I change the combo box (names), instead
of all the fields in the form updating to the new record, it is just changing
the current record's field name. I am unsure how to connect the other records
to that combo box? I also want to have another combo box so that i can narrow
my search even further, is this possible?

I know it has been awhile since this post. However I am running into the same
problem again. I have two unbound combo boxes that work appropriately. In the
recordsource of the form I have

Select * From [Table1] Where [Name] Like nz(Forms![Combo1],"*")
And [Name2] Like nz(Forms![Combo2],"*")

In combo2's after update procedure, I have me.requery

Everytime I change combo2, the form goes back to the first record in the
table and not the record chosen in combo2.....any suggestions?

"Ofer" wrote:

The combo box should be unbound.
The recordsource should be filtered by the value of the combo

Select * From TableName Where NameField Like nz(Forms![ComboNameInForm],"*")

Or if you using two combo's
Select * From TableName Where NameField Like nz(Forms![ComboNameInForm],"*")
And NameField2 Like nz(Forms![Combo2NameInForm],"*")

On the after update event of the combo. write the code me.requery

"JJ" wrote:

I put a combo box in my form, so that i can click on names. The combo box is
based off of a query from a table. As I change the combo box (names), instead
of all the fields in the form updating to the new record, it is just changing
the current record's field name. I am unsure how to connect the other records
to that combo box? I also want to have another combo box so that i can narrow
my search even further, is this possible?

The path to the combo should be

Forms![Formname]![Combo1]
Forms![Formname]![Combo2]
--
I hope that helped
Good luck


"JJ" wrote:

I know it has been awhile since this post. However I am running into the same
problem again. I have two unbound combo boxes that work appropriately. In the
recordsource of the form I have

Select * From [Table1] Where [Name] Like nz(Forms![Combo1],"*")
And [Name2] Like nz(Forms![Combo2],"*")

In combo2's after update procedure, I have me.requery

Everytime I change combo2, the form goes back to the first record in the
table and not the record chosen in combo2.....any suggestions?

"Ofer" wrote:

The combo box should be unbound.
The recordsource should be filtered by the value of the combo

Select * From TableName Where NameField Like nz(Forms![ComboNameInForm],"*")

Or if you using two combo's
Select * From TableName Where NameField Like nz(Forms![ComboNameInForm],"*")
And NameField2 Like nz(Forms![Combo2NameInForm],"*")

On the after update event of the combo. write the code me.requery

"JJ" wrote:

I put a combo box in my form, so that i can click on names. The combo box is
based off of a query from a table. As I change the combo box (names), instead
of all the fields in the form updating to the new record, it is just changing
the current record's field name. I am unsure how to connect the other records
to that combo box? I also want to have another combo box so that i can narrow
my search even further, is this possible?