Subform Difficulties

  • Thread starter Thread starter Matthew DeAngelis
  • Start date Start date
M

Matthew DeAngelis

Hello everyone,

I'm having a bit of an issue. I have two subforms on one main form:
one is in datasheet view and displays the date, time, contact, etc. of
a series of transactions with a particular company. This one works
fine. The other one is directly below it, in single form view, and
displays the notes for that particular transaction (only one note per
transaction) My problem is that I have tried to link the notes subform
to the TransactionID in the transactions subform, and every time I load
the main form, the notes subform prompts the user to input that same
TransactionID. I assume this is because the forms are loading
simultaneously, so there is no number to grab. It will prompt me
whether or not there are any transactions for the company in question,
which is the first thing I tried. If possible, I would like to have
this form embedded instead of as a popup, as it makes viewing easier,
and I can't simply put the field in the transaction subform footer,
because it won't show up in datasheet view (or can I make it do that?).

Any thoughts?


Thanks,
Matt
 
Matthew said:
Hello everyone,

I'm having a bit of an issue. I have two subforms on one main form:
one is in datasheet view and displays the date, time, contact, etc. of
a series of transactions with a particular company. This one works
fine. The other one is directly below it, in single form view, and
displays the notes for that particular transaction (only one note per
transaction) My problem is that I have tried to link the notes
subform to the TransactionID in the transactions subform, and every
time I load the main form, the notes subform prompts the user to
input that same TransactionID. I assume this is because the forms
are loading simultaneously, so there is no number to grab. It will
prompt me whether or not there are any transactions for the company
in question, which is the first thing I tried. If possible, I would
like to have this form embedded instead of as a popup, as it makes
viewing easier, and I can't simply put the field in the transaction
subform footer, because it won't show up in datasheet view (or can I
make it do that?).

Any thoughts?


Thanks,
Matt
Click to expand...


Nevermind...I just put the thing in Continuous Forms and placed the
Notes field in the footer.

Sorry for the bother and thanks anyway.


Matt
 
Back
Top