Query or form wizard?

[Lol Owen]

Hi, another annoying problem that I just cannot figure. I have a query based on multiple tables. Run the form wizard on the query and it creates a nice form with embedded subform. However, try and make another form from the same query, or another form from an identical separately built query, and I don't get the option to have subforms or linked forms. I just get one big form. Not good, in fact infuriating. if I create a form form a query, and then change the query, such as by adding to a criteria to do search functions (Like[]), how can I refresh or update the form so that it takes into account of the changes to the query?

A lot to ask, but I just can't fathom these out.

Thanks, Lol

 

[Kraj]

I'm sure there is a fix for your problem, but my suggestion would be to practice making forms without the wizards. You'll get a greater understanding of the "guts" of things, which makes it easier to customize and to fix things that don't work right when automatically generated.

 

[Lol Owen]

That's cool, but how do you go about getting the subforms in when built in design view? This is where the wizard is driving me nuts, I know what I want to do but it's inconsistency is just being a pain.

Cheers, Lol

 

[Kraj]

Subforms are an available control on the toolbar, just like a label or text box. They're near the bottom; once you draw your box and wizard will help with choosing the subform source and linking it to the master form. (I know, it's a wizard. But it is a useful wizard and generally will not do things you don't want it to do.)

Oh, and I see I forgot to answer your initial second question. If you make changes to a form's underlying query, such as adding a field, then you will have to add the field on your form as well. The form will know a new field is available in the query but will not automatically pop it on there for you. If you make changes to the query criteria or other things pertianing to the data itself, the form *probably* won't care.

 

[Lol Owen]

Cheers Kraj, I'll give it a try and see what I can come up with.

Lol