stop the loading of subform

  • Thread starter Thread starter manish
  • Start date Start date
M

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
 
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)
 
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
 
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 said:
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





.
Click to expand...
Click to expand...
 
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
Click to expand...
(subreportname.Report.HasData,subreportname.report.txtTotal
,0)
--
Duane Hookom
MS Access MVP


can anyone tell me the code or whatever to stop a
Click to expand...
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


.
Click to expand...
Click to expand...


.
Click to expand...
 
The control source of a text box.

--
Duane Hookom
MS Access MVP


manish said:
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


.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top