stop the loading of subform

can anyone tell me the code or whatever to stop a form & a
subform from being loaded if the related query does not
contain any records?? This is because it shows error signs
on report.
any help will be highly appreciated as i do not know
anything about coding.
thanks in advance.

manish

If you have a text box that references a subreport control value, you can
use something like:
=IIf(subreportname.Report.HasData,subreportname.re port.txtTotal,0)

--
Duane Hookom
MS Access MVP


"manish" wrote in message
...
can anyone tell me the code or whatever to stop a form & a
subform from being loaded if the related query does not
contain any records?? This is because it shows error signs
on report.
any help will be highly appreciated as i do not know
anything about coding.
thanks in advance.

manish

Dear Duane
I am still not being able to stop the subform from loading
when there is no data.
Form name - 'mainform'
subform name - 'subform'

i have tried to enter the following formula in various
places but error pops up.


=IIf([subform].report.HasData,[subform].Report.amt,0)

amt is the field of the subform

Please HELP!!!

regards

manish


-----Original Message-----
If you have a text box that references a subreport
control value, you can
use something like:
=IIf
(subreportname.Report.HasData,subreportname.report .txtTotal
,0)

--
Duane Hookom
MS Access MVP


"manish" wrote in
message
...
can anyone tell me the code or whatever to stop a form
& a
subform from being loaded if the related query does not
contain any records?? This is because it shows error
signs
on report.
any help will be highly appreciated as i do not know
anything about coding.
thanks in advance.

manish


.

This is a reports NG. If you have form questions, you should ask in a Forms
news group. It is much less confusing that way.

If you are indeed talking about reports, you need to provide the name of
your subreport control name as well as the name of the control on the
subreport.

--
Duane Hookom
MS Access MVP


"manish" wrote in message
...
Dear Duane
I am still not being able to stop the subform from loading
when there is no data.
Form name - 'mainform'
subform name - 'subform'

i have tried to enter the following formula in various
places but error pops up.


=IIf([subform].report.HasData,[subform].Report.amt,0)

amt is the field of the subform

Please HELP!!!

regards

manish


-----Original Message-----
If you have a text box that references a subreport
control value, you can
use something like:
=IIf
(subreportname.Report.HasData,subreportname.report .txtTotal
,0)

--
Duane Hookom
MS Access MVP


"manish" wrote in
message
...
can anyone tell me the code or whatever to stop a form
& a
subform from being loaded if the related query does not
contain any records?? This is because it shows error
signs
on report.
any help will be highly appreciated as i do not know
anything about coding.
thanks in advance.

manish


.

Dear Duane
Where do i put the code??
Sorry about the form thing. Actually i meant report.
regards
manish

-----Original Message-----
This is a reports NG. If you have form questions, you
should ask in a Forms
news group. It is much less confusing that way.

If you are indeed talking about reports, you need to
provide the name of
your subreport control name as well as the name of the
control on the
subreport.

--
Duane Hookom
MS Access MVP


"manish" wrote in
message
...
Dear Duane
I am still not being able to stop the subform from
loading
when there is no data.
Form name - 'mainform'
subform name - 'subform'

i have tried to enter the following formula in various
places but error pops up.


=IIf([subform].report.HasData,[subform].Report.amt,0)

amt is the field of the subform

Please HELP!!!

regards

manish


-----Original Message-----
If you have a text box that references a subreport
control value, you can
use something like:
=IIf

(subreportname.Report.HasData,subreportname.report .txtTotal
,0)

--
Duane Hookom
MS Access MVP


"manish" wrote in
message
...
can anyone tell me the code or whatever to stop a
form
& a
subform from being loaded if the related query does
not
contain any records?? This is because it shows error
signs
on report.
any help will be highly appreciated as i do not know
anything about coding.
thanks in advance.

manish


.



.

The control source of a text box.

--
Duane Hookom
MS Access MVP


"manish" wrote in message
...
Dear Duane
Where do i put the code??
Sorry about the form thing. Actually i meant report.
regards
manish

-----Original Message-----
This is a reports NG. If you have form questions, you
should ask in a Forms
news group. It is much less confusing that way.

If you are indeed talking about reports, you need to
provide the name of
your subreport control name as well as the name of the
control on the
subreport.

--
Duane Hookom
MS Access MVP


"manish" wrote in
message
...
Dear Duane
I am still not being able to stop the subform from
loading
when there is no data.
Form name - 'mainform'
subform name - 'subform'

i have tried to enter the following formula in various
places but error pops up.


=IIf([subform].report.HasData,[subform].Report.amt,0)

amt is the field of the subform

Please HELP!!!

regards

manish


-----Original Message-----
If you have a text box that references a subreport
control value, you can
use something like:
=IIf

(subreportname.Report.HasData,subreportname.report .txtTotal
,0)

--
Duane Hookom
MS Access MVP


"manish" wrote in
message
...
can anyone tell me the code or whatever to stop a
form
& a
subform from being loaded if the related query does
not
contain any records?? This is because it shows error
signs
on report.
any help will be highly appreciated as i do not know
anything about coding.
thanks in advance.

manish


.



.