stop the loading of subform

[manish]

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

 

[Duane Hookom]

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)

 

[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

 

[Duane Hookom]

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

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]

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

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


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


.

.

 

[Duane Hookom]

The control source of a text box.

--
Duane Hookom
MS Access MVP

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

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


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


.

.