pa****@gmail.com wrote:
On my Main form I have a Command Button that opens a Subform in order
to create a new Subform record.
If the button "opens" the other form then it is not a subform. A subform is
one form embedded inside of another. If you open the form separately then
it is just a standard form and it will not inherit the foreign key values
from your other form as it would if it were a true subform.
At this point I want the subform to show only the new record being
created.
Not all the records the subform's table has.
I cannot put the subform as Data Entry because I cannot print the main
form & subform together if the subform is "data entry". (comes up
blank every time)
Forms suck at printing. Make a report instead. Besides if you save the
record on the subform before printing then it won't be blank any longer.
What code do I use to filter all subform records except for the
current?
If you are adding a record then you have no "current" record to filter on.
Or what code do I use to print out the current Main Form, & individual
Subform record.
As stated, don't print forms.
(acSelection) does not work, it prints out all subform records.
I dont want to make reports, I want to print the form itself exactly
how it is
You can make a report that looks just like the form except that it will work
proerly for printing. As a head start you can right-click the form in the
dbWindow and choose "save as report".
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com