Conditional Layout of From

[spinalwiz]

Im trying to layout my form based upon the results from a query.

I would like each record in the query to be displayed on the form at the same time, so that each record will have a label for the title and a listbox to display some info.

So if there was 1 record in the query there would be 1 label and 1 listbox.

If there were 3 records in the query then there would be 3 labels and 3 listboxes.

Any ideas to point me in the right direction?

Thanks

 

[hymn]

not 100% sure what you mean but do you want continuous forms if so

design view of the form
Properties
default view
Select continuous forms

Hope this helps
Hymn

 

[spinalwiz]

Thanks,

Im new to access and this sounds like the type of thing I was looking for. I'll give it a go and see if it works out.

 

[spinalwiz]

Hmmmm . . .not sure because I dont want the whole form to repeat, just a little bit of it. Maybe I could add a subform and make that a continous form.

I think basically what I want to do is something like

For each entry in Combbox
Add Label
Add Listbox


Any ideas?

 

[hymn]

you could try datasheet insread of continuous or create a subform with either datasheet or continous

Hope this helps
Hymn

 

[spinalwiz]

Is it possible to make a subform that is bound to a query thats uses values from the controls in the main form?

It seems I can only bind a subform to an existing object.

 

[spinalwiz]

Ive now got a continous subform. But Im having a problem

Say Ive got 3 records showing in my continuous subform looking like this:

---
ID: 1
Price: 2
---
ID: 2
Price: 5
---
ID: 3
Price: 10


Now say I want to add a text box that would show the ID * Price for each one. So for record 1 it would be 1 * 2, record 2 would be 2 * 5, etc.

When I tried to do this it just seemed to use the values from the 1st record for all the other records, i.e. the text box showed 1 * 2 for all records.

 

[hymn]

Sorry for the delay been out and busy
What fields are in the table you are using? what is in the query? what is on the form/subform?

Hope this helps
Hymn