Form based on queries

[Krash878]

I have multiple forms based on queries and some times they open blank. Is there a way that if they are going to be blank to not open them at all?

 

[TTThio]

Usually even there's no data returned, the form will still be opened with no data. Not go blank. If it's going blank, it means something wrong with the query or the unjoined relationship. One way, you can set the query property to Dynaset Inconsistent to return no data instead of blank.

However, if you just think of canceling the form opening when there's no data, I'll say on Form_Load, create recordset, if isnull(rs.recordcount) then close form. This can be done through code or macro (cancelEvent).

Hope you work it out.

 

[Kubilus1]

I have a similar problem. I have forms with subforms based on pass-through queries. Sometimes the forms will open with an empty set.

I would like to show the form with blank data; however, the main form opens blank, and the subform brings up an error (err# 2455). I link the recordsource to the form through code, not through design view.

I tried setting the form and subform as Dynaset Inconsistent, as described above, but this did not help.

Any idea how to open a form based on empty data showing empty fields instead of a blank form?

Thanks a lot,
Matt

 

[TTThio]

The other way to do that, you need to set the form/subfrom AllowAddition property to Yes. Then it will display blank fields, not dimmed/blank form.

 

[Kubilus1]

No, AllowAddition property was already set to Yes. Still blank form and an error for the subform (apparently you can't link a subform to empty data). Any other ideas?

Thanks,
Matt

 

[TTThio]

Sorry, last time I got the same problem, it was fixed that way. However, if you'd like, you can send me a sample.zip file for me to figure it out.

tin.tin.thio@terabeam.com