Data Entry

[Saintsman]

Hi
My form has 2 list boxes - list2 is a filtered depending on what is selected
in list1
On my subform where I add new records I apply a filter to a combo1 that
allows me to select from a filtered list depending on list2 selection
What happens is that when I select a different option from either list1 or
list2 my combo1 box does not show what has been selected on previous records.
How do I maintain these previous selections on the screen?

Saintsman

 

[Arvin Meyer [MVP]]

The code that you run for 1 record in a subform, affects them all. This
because a subform is really only 1 record, the rest are dependent. What I've
always done is to create a separate popup form to change the record in the
subform, and use the subform as a read only display. Once the editing is
done on the popup, requery the subform and you should see the correct
results.

 

[Saintsman]

I can see how that would work when entering new data, but what about when I
need to amend existing - I still want the list boxes functionality etc

 

[Arvin Meyer [MVP]]

It would work the same way. Use a double-click event on the record selector
(which is the same as the form's double-click event) to open the editing
form. I realize that this is less than ideal, but it is a simple workaround
to the problem. Subforms are not really forms at all, they are controls with
form properties. As such, running code in a single record, can affect them
all.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com