Drop-down box

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

Guest

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


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

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]
 
Back
Top