467,877 Members | 1,257 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,877 developers. It's quick & easy.

Select current record ability

I have a form in access that has 5 fields for a certain record: 1)Date
mailed, 2)Date received, 3)Date completed 4)Foreign Content amount and
5)record number. If the foreign content (FC)is >15% of the invoice
amount (inv amt.on another form) then I want a my report to run
automatically for the record I am on in the current EC Input form when
I enter in the foreign content amount. I have a query built for the
report. Currently, when the user enters in the FC in the EC input
form they must make their own calculation to see if the FC is >15% of
invoice then run the FC report. If it is >15% then they run the report
but the way I have it now is a pop up screen saying "enter in the
record #".

How can I make it to where right after you tab out of the FC field
access will calculate the FC amount and then if FC>15% of invoice the
report will automatically run for the current record? I think I might
be able to figure it out if I can make the report run for the current
record. The most impt is to know how to get away from entering in the
record number on the pop up screen. If I knew this current record
option then I could apply it to many different areas.

Thank you,
Tony
Nov 12 '05 #1
  • viewed: 8522
Share:
1 Reply
Tony,

To run your report for the current record:
I think all you need to do is To use something like Forms!FrmYourFormName!RecordID
in your query-condition. instead of [Enter in the record]

--
Hope this helps
Arno R
"Tony" <et*@wt.net> schreef in bericht news:ad**************************@posting.google.c om...
I have a form in access that has 5 fields for a certain record: 1)Date
mailed, 2)Date received, 3)Date completed 4)Foreign Content amount and
5)record number. If the foreign content (FC)is >15% of the invoice
amount (inv amt.on another form) then I want a my report to run
automatically for the record I am on in the current EC Input form when
I enter in the foreign content amount. I have a query built for the
report. Currently, when the user enters in the FC in the EC input
form they must make their own calculation to see if the FC is >15% of
invoice then run the FC report. If it is >15% then they run the report
but the way I have it now is a pop up screen saying "enter in the
record #".

How can I make it to where right after you tab out of the FC field
access will calculate the FC amount and then if FC>15% of invoice the
report will automatically run for the current record? I think I might
be able to figure it out if I can make the report run for the current
record. The most impt is to know how to get away from entering in the
record number on the pop up screen. If I knew this current record
option then I could apply it to many different areas.

Thank you,
Tony

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Christian Wetzig | last post: by
3 posts views Thread by William Wisnieski | last post: by
2 posts views Thread by Chris Plowman | last post: by
5 posts views Thread by john | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.