access combo box inserted same infomation in all forms

[Guest]

When I make a combo box in a form. The information I type in any one form is
repeated in all forms.

 

[John Vinson]

On Mon, 9 Oct 2006 10:20:02 -0700, Stonewall Jackson <Stonewall

When I make a combo box in a form. The information I type in any one form is
repeated in all forms.

Could you perhaps be a bit less obscure here?

All *FORMS*? Do you have multiple Access Forms open? Or do you mean
all records in a Form?

What's the Recordsource property of the form (or forms)?

What's the Control Source property of the Combo Box?

Groping in the dark for a guess here: maybe you have a continuous Form
with an unbound (blank control source Combo Box) on it. Since the
combo isn't bound to any field in any table, it will show the same
value for all rows of the continuous form. If you want to store that
value in a table, there must be a field in the table, and the combo
must be bound to that field.

John W. Vinson[MVP]

 

[Guest]

I apoligise for my obscurity, I think you gave me the correct answer which
raises more questions.

1) How do you bound a combo box to a form? My database will be used to sort
drawing files and does not require "relationships" I don't think.

Thank you for your response.

 

[John Vinson]

I apoligise for my obscurity, I think you gave me the correct answer which
raises more questions.

1) How do you bound a combo box to a form? My database will be used to sort
drawing files and does not require "relationships" I don't think.

You don't, and can't, "bound a combo box to a form".

Data is not STORED in forms. It's stored in Tables, and only in
Tables. Forms are just tools, windows which let you edit the data in
Tables. And if you have both a Form and a combo box, it sounds like
you have two tables (the Form's Recordsource, the records which the
form is displaying, and the Combo's RowSource, the values which the
combo displays); I suspect that you *do* need some relationships.

Stop, step back, and maybe read some of the references in Jeff's
Database Design 101 links or the introductory material on the Access
Web. If you're going to use Access, you should be prepared for a
somewhat steeper learning curve than in Word or Excel.

Jeff Conrad's resources page:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

John W. Vinson[MVP]

 

[Rick Brandt]

Dear Sir,

When I change a box to a combo box on my form and bound it to the proper
table, the resulting pull down menu is not in alphabitical order on the form
alough it is in order on the table, can you help me?

Change the RowSource from the name of the table to a query that pulls the values
from the table. Then apply the desired Sort on the query.

 

[John Vinson]

Thank you for your responce, I created a query using the table and sorted
alphabitically, and changed the row source to the query, still it appears on
the form not in alphabitical order, I might add it is only this of 5 combo
boxes on this form that I am having this problem with. I would appreciate any
other suggestions you might have.

The sorting of the Combo Box (its rowsource) and the sorting of the
Form (the Form's Recordsource) are two completely independent
operations. If you want to sort the records on the Form, base the Form
on a sorted query; if you want to sort the records in the Combo, base
*it* on a (different) sorted query.

John W. Vinson[MVP]