Frame list

[pm4698]

Hi there!

I have a form with combo boxes, where i select surnames from a table.
In that table i have a field that is a combobox named situation and takes 2 values - d_n and e_w.

I want to insert a frame list in the form. In that frame list i want to show all the surnames(in a list) which do not appear in the combo boxes of the form and the combobox situation, has the value d_n.

How can i do this?

Also, i want to "break" the frame list into 2 frame lists and when-if one frame lists gets full of surnames then the surnames appear in the next frame list.

Any ideas?

Thanks in advance

 

[DCrake]

Not quite sure what you mean when you say Frame List? are you talking about list boxes?

David

 

[pm4698]

Yes
Really sorry

I mean list boxes (i translated it directly from greek! )

 

[DCrake]

List boxes never get full, theoretically so there is no need to have more than one. Still unsure about your first statement can you elaborate please.

David

 

[pm4698]

i have a form with combo boxes, from where i select surnames (field of a table).
In that table, i have a field that is a combobox named "situation" and takes 2 values:
d_n and e_w

I want to insert a list box in the from. In that listbox i want o show all the records (field: surname from table), which do not appear at the rest combo boxes of the form AND the field - combobox "situation" has the value d_n.

Refering to the statement that list boxes never get full, 'cause i am going to print this form, i need all the surnames to be seen, thats why i need a second list box

 

[DCrake]

The list of surnames can be in a sub report in your detail section and the section will grow/shrink accordingly. You need to use filter to extrtact the data you are trying to display.

David

 

[pm4698]

could you give me an example 'cause i'm kind of rookie in access and i try to learn?

Thanks in advance

 

[DCrake]

Is this a real life stiuation or assignment?

 

[pm4698]

its like an assignment.

We have a lesson called "Databases" and we work on access.

So, i created myself an imaginary database and try to learn extra stuff!

 

[DCrake]

Then I suggest you try something that you can do now before moving onto something you can't do. Let F1 be your friend.

David