very important showing results in realtime along with options

[xena_morph]

ive asked this before but still really need help,

i want to have options be they yes/no and drop down lists at the top of the form

below this i want the results of selecting yes for an option or a place on the list to appear in a subform below in realtime - so that is i change my mind about an option the results change straight away, is there anyway of doing this

thanks in advance


i would also then like the option ofchoosing one from this list of results and blowing it up to show all info on a seperate page if required,


i know its a lot to ask and vba isnt particularly good but i can follow instructions

Jill

 

[JCross]

i'm not really clear on what you're trying to do - but you can have the 'results' show up on the update or change of the control that was selected. for example - when you have a combo box with a list of names and you want to choose a name and have a record appear....the record appears 'immediately'. is that the kind of thing you're looking for?

 

[xena_morph]

its like to begin with on the left no options are chosen so in the sub form on the right all properties are shown, this list is reduced when for example the toggle button gor garage os selected so that any property without a garage is removed from the list, other options i want on it are max prive and area

 

[JCross]

so something like 'IF no garage THEN (change the value of the query to exclude garages)'

i don't know what your tables are named or what your query looks like, but i think that's what you would have to do.

but i think it would be easier if you had a 'search' button on the form..so the choices could be made THEN you run through them, but the values of the controls in the query for the subform, and have the results show.

anyone else know a better way?

jen

 

[David R]

To change the values in the subform based on a selection made from a combo up top, use the AfterUpdate event of the combo box to requery the subform, or redefine what it holds, perhaps. I'm not at all clear on what you're asking though, so I could be off track.

It sounds like you're going to have to build new SQL statements every time you change a checkbox. Have you looked into Query by Form?

Good luck,
David R