Continuous Form - List box in Access97

[kramerica]

I am having a problem with continous forms and using List boxes in Access 97. (I need to display in Continous Forms)

Access 97 does not allow a Sub-form in a continous form.

I am using a continous form to display all of my records and then a listbox that displays any 'codes' that are tied to the existing record. The problem that I am having is that all the list boxes on all of the records display whatever my current records list box data should be.

For example if I have 4 records: Orange, Apple, Grape, Bannana. The listbox for each record should list the Color.

I am expecting to see:

Orange - orange
Apple - red
Grape - green
Bannana - yellow

Instead - when I am on record Orange this is what I see:

Orange - orange
Apple - orange
Grape - orange
Bannana - orange

Then when I select the Apple record all list boxes display 'red'.

Each Record has a unique Record Number and the listbox is tied to the unique number in the bound column of the listbox. (if I switch to regular form mode everything works fine.) Is there a better way to do this?

Any ideas?

 

[WildHare]

How many "colors" can a record have? Why are you using a list box if there can be only one value in it?

Might you be better served with a combo box bound to the COLOR field? I have a sneaking suspicion that this is what you need.

Remember, you're unique - just like everyone else
You're invited to visit another free Access forum:

http://www.forumco.com/jmhare

or my site,

http://www.jmhare.com

 

[kramerica]

The list box is displaying several values. The benefit of the list box is that it can display all of the values without clicking on it. The combo box would have to be clicked on to display the values.

For Example: Apple - the list box would display Color and Quantity

Orange - orange, 7
Apple - red, 6
Grape - green,3
Bannana - yellow, 9

 

[WildHare]

Well, you kinda lost me on that - combo boxes can display multiple columns too...still can't see the NEED for list box unless you're displaying more than one OCCURANCE of something, as opposed to more than one CHARACTERISTIC of something.

APPLE  -  red  - 12  < One OCCURENCE, THREE characteristics

Remember, you're unique - just like everyone else
You're invited to visit another free Access forum:

http://www.forumco.com/jmhare

or my site,

http://www.jmhare.com

 

[JSchumacher]

I see that this question was never answered. It's exactly the question I came in here looking for the answer to. In my instance I have two tables:

tblPaymentSet
SetID
PersonID
SetDate
SetStatus

tblPaymentPlan
PlanID
SetID
PlanDate
PlanAmt
PaymentTypeID

tblPaymentSet will have a handful of entries in tblPaymentPlan. I want my continuous form to list each plan and the terms of that plan.

Any assistance would be appreciated. Thanks!

Judie