Problems with multiple combo boxes

[Guest]

In one of my forms I have 4 combo boxes that are dependant on each other for
infomation. When you select the first one, it sets the values for two other
boxes, when you select on of the second boxes it sets the value for the 4th
box. I did this based on a tutorial on the MS Office web site.

The problem that I am having now is that when I go from one record to the
next, the settings in the combo boxes are the same. It's not that the data in
the boxes carry over, in the actual boxes, but the values contained in those
boxes effects all of the other records.

For example, I'm creating a coin database. When I put in the relevant info
(MintMark, Denomination and Series) in the first record, then I go to the
next record, if these settings are not the same, when I change them it
effects the settings on the first record.

Thanks,
David

 

[Steve]

One way to get around this is to use two forms; one form foe data entry and
one form to list your coins but no data entry. For the first form, use a
single form with your four comboboxes for data entry. When you go record to
record, the next record will not be affected by the previous record. For the
second form, use a continuous and use textboxes rather than comboboxes for
the four fields. Lock all the fields to prevent data entry. This form is for
display only. You could put code in one of the fields where clicking on the
field would open the first form for editing and deleting records. You could
also have a button with code on the first form to open the second form. If
you opt to do this, think out all the logic beforehand.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[StopThisAdvertising]

One way to get around this is to use two forms; one form foe data entry and
one form to list your coins but no data entry. For the first form, use a
single form with your four comboboxes for data entry. When you go record to
record, the next record will not be affected by the previous record. For the
second form, use a continuous and use textboxes rather than comboboxes for
the four fields. Lock all the fields to prevent data entry. This form is for
display only. You could put code in one of the fields where clicking on the
field would open the first form for editing and deleting records. You could
also have a button with code on the first form to open the second form. If
you opt to do this, think out all the logic beforehand.

PC Datasheet

--
This is to inform 'newbees' here about PCD' Steve:
http://home.tiscali.nl/arracom/whoissteve.html
Until now 3650+ pageloads, 2350+ first-time visitors (these figures are rapidly increasing)

Why is this ???
Because Steve is the ONLY person here who continues to advertise in the groups.

It is not relevant whether he advertised in *this* particular post or not...
==> We want him to know that these groups are *not* his private hunting grounds!

For those who don't like too see all these messages:
==> Simply killfile 'StopThisAdvertising'.
Newbees will still see this warning-message.

ArnoR

 

[tina]

sounds like you're using a form in Continuous view or Datasheet view, where
you see multiple records at the same time. you have the code running in the
combo boxes' AfterUpdate events, to filter those dependent combos already;
try adding the same code to the *form's* Current event procedure, as well.
so as you move from one record to another, the combo boxes' filtering will
always be appropriate to the record you're currently on.

hth