fields are not sychronized in form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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],"*")
 
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 said:
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],"*")

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?
Click to expand...
Click to expand...
 
The path to the combo should be

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


JJ said:
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 said:
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],"*")

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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top