Select current record ability

[Tony]

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

[Arno R]

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