Drop-down box

C

C Ventura

I am trying to make a database to keep track of all incoming/outgoing
correspondence. I have made a drop down box with information such as UCMJ,
Memo, Letters, etc. This way, all I would have to do is point at one of
these and it will place it in the block for me. The problem that I am
encountering is that I select one of my choices, it carries on to the next
record. If I change the following record, it will change the one prior as
well. Please tell me what am I doing wrong. Also, I have a few slots where
I would like to place the names of the people I'm forwarding the
correspondence to along with the date it takes place. Again, the information
I put in there is still showing up on the new records. Please, help.
 
J

John Vinson

On Wed, 2 Mar 2005 12:45:05 -0800, C Ventura <C
I am trying to make a database to keep track of all incoming/outgoing
correspondence. I have made a drop down box with information such as UCMJ,
Memo, Letters, etc. This way, all I would have to do is point at one of
these and it will place it in the block for me. The problem that I am
encountering is that I select one of my choices, it carries on to the next
record. If I change the following record, it will change the one prior as
well. Please tell me what am I doing wrong.


It would appear that you have a continuous Form and that the drop down
box is "unbound" - that is, its Control Source is blank. As such, it's
not storing the selected value anywhere; and since a continuous form
only *appears* to have multiple rows of controls (it actually has one
row of controls displayed multiple times), changing the value of the
combo box in one record changes the value in all rows on the screen
(since it's not being stored in any field in the table).
Also, I have a few slots where
I would like to place the names of the people I'm forwarding the
correspondence to along with the date it takes place. Again, the information
I put in there is still showing up on the new records. Please, help.

Again... same problem. You may be making the very common mistake of
starting your design with the Form; instead, you should base your
design on the Tables, which should contain fields for the
correspondance type, the forwards (in a second table related
one-to-many to the correspondance table), and so on.

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top