How do I refer to and use fields on subform for math calcs etc.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have form that has a subform that contains lists of numbers that need to be
used in calculations and then stored in a table.

First how do I refer to the field to perform a calculation or error checking
such as:

If SubformField < 0 then
.......

And

Answer1 = SubformField * 2

And

rstPP.Field = SubformField

I need to do all 3 types of things with these subform fields and I'm having
trouble accessing them.

Thanks for any help you can give.
 
I have form that has a subform that contains lists of numbers that need to be
used in calculations and then stored in a table.

First how do I refer to the field to perform a calculation or error checking
such as:

If SubformField < 0 then
......

And

Answer1 = SubformField * 2

And

rstPP.Field = SubformField

I need to do all 3 types of things with these subform fields and I'm having
trouble accessing them.

Thanks for any help you can give.
Click to expand...

Refer to Form and Subform properties and controls
http://www.mvps.org/access/forms/frm0031.htm
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
Thanks so much. What a great page of information.

Everythings working well! Appreciate it!
 
Thanks so much. What a great page of information.

Everythings working well! Appreciate it!
Click to expand...

Glad I could help.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
U¿ytkownik "KmhComputer said:
I have form that has a subform that contains lists of numbers that need to be
used in calculations and then stored in a table.

First how do I refer to the field to perform a calculation or error checking
such as:

If SubformField < 0 then
......

And

Answer1 = SubformField * 2

And

rstPP.Field = SubformField

I need to do all 3 types of things with these subform fields and I'm having
trouble accessing them.

Thanks for any help you can give.
Click to expand...

============================================================================
================
FULL LEGAL SOFTWARE !!!
Games, video, program, image, chat, questbook, catalog site, arts, news,
and...
This site it is full register and legal software !!!
Please download and you must register software !!!

PLEASE REGISTER SOFTWARE:
http://www.webteam.gsi.pl/rejestracja.htm
DOWNLOAD LEGAL SOFTWARE:
http://www.webteam.gsi.pl

Full question and post: http://www.webteam.gsi.pl

Contact and service and advanced technology:
http://www.webteam.gsi.pl/kontakt.htm
FAQ: http://www.webteam.gsi.pl/naj_czesciej_zadawane_pytania.htm

Please add me URL for you all site and search engines and best friends !!!

Me site:
SERWIS WEBNETI: http://www.webneti.gsi.pl
PORTAL WEBTEAM: http://www.webteam.gsi.pl
LANGUAGE: http://www.webneti.cjb.net
============================================================================
================
 
Back
Top