Row Source property on an Access Form

[mjpereira76]

HI,

I have a continuous form for entering orders and on the form I am using
a combo box so that the person may be able to select the company they
are ordering from. For now, this combo box is unbound and the data
that populates the list is selected using a SQL SELECT statement. The
thing that I can't figure out is that when I view the form which has
multiple enteries from a bound table, whenever I make a selection of a
company listed in the combo box, every combo box for every single
record on the form will default to the value I chose in the first
record. Any idea why this happening?

Thanks for your help,

Mario

 

[Douglas J. Steele]

That's the way unbound controls are: while it may look like there are, say,
20 different combo boxes on the form, there's only one, repeated 20 times.

There's no way around that.

 

[mjpereira76]

That's the way unbound controls are: while it may look like there are, say,
20 different combo boxes on the form, there's only one, repeated 20 times.

There's no way around that.