combo box on a continuous form again

[Alex]

Sorry, guys. But, my question was sunken in replies.
So, I'm repeating it.

Yes, the combo box is bound to a field of a table. Is it
possible in this case to have data entered (appeared) for
only one row not for all?
Thanks

-----Original Message-----
Is your combobox bound to a field in the table or query behind the form? If
not then you will see the results you do.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm





.

..

 

[Cheryl Fischer]

Yes.

However, just saying the combo box is bound to a field of *A* Table is not
enough to assure that it will work the way you want. Your combo box must
be bound to a field in The Record that is the record source of your
continuous form. Check the Control Source property of the combo box; if
it does not have a field name in it that is also a field in the form's
record source, then you will certainly see the "all rows contain the same
value" behavior.

 

[Alex]

Thanks. I did it. It looks like working.

-----Original Message-----
Yes.

However, just saying the combo box is bound to a field of *A* Table is not
enough to assure that it will work the way you want. Your combo box must
be bound to a field in The Record that is the record source of your
continuous form. Check the Control Source property of the combo box; if
it does not have a field name in it that is also a field in the form's
record source, then you will certainly see the "all rows contain the same
value" behavior.

--

Cheryl Fischer, MVP Microsoft Access






.

 

[Cheryl Fischer]

Good to hear, Alex! Thank you for letting us know and good luck with your
project.