rewriting a table row from a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kati h - 31 Jan 2007 23:07 GMT

I have set up an entry screen (form) to provide header information to print
on invoices. The key field is also entered on this screen to extract the
rest of the invoice information from other tables. It looks like I have to
set up a one row table to accept this information, and to base the form on.

My question is, how do I rewrite this record (row) every time other than add
another one? I only want to print one invoice at a time, but it will always
be different.

Signature

kati h

Reply to this Message

Nikos Yannacopoulos - 01 Feb 2007 10:00 GMT

Kati,

If I understand your situation correctly, you need a way to print a
comment on invoices, which is manually entered right before you print,
and does not need to be saved? If this is indeed the case, then you do
not need a table at all. Your form does not need to be bound to a table;
what you need is an unbound text box on the form to type the comment in,
and a text box on the report (from which you print off the invoice)
which reads the comment directly from the textbox on the form! To
achieve this, assuming the form is maned MyForm, and the text box on it
is named txtComment, you need to change the Control Source property of
the text box in the report to:
=Forms![MyForm]![txtComment]

Just make sure the form is open and the text is typed in before you print.

HTH,
Nikos

> I have set up an entry screen (form) to provide header information to print
> on invoices. The key field is also entered on this screen to extract the
[quoted text clipped - 4 lines]
> another one? I only want to print one invoice at a time, but it will always
> be different.

Reply to this Message

kati h - 01 Feb 2007 14:12 GMT

I think I do need to keep the one record because the job number that is
entered on the form is the key to three other tables I need to create an
invoice. Any ideas? Maybe there is a better way to do this.

Signature

kati h

> Kati,
>
[quoted text clipped - 23 lines]
> > another one? I only want to print one invoice at a time, but it will always
> > be different.

Reply to this Message

Larry Daugherty - 04 Feb 2007 22:59 GMT

On that same form place a textbox for the job number and yse its value
to lookup the other things you need:

=Forms![MyForm]![txtJobNo]

HTH

Signature

-Larry-
--

> I think I do need to keep the one record because the job number that is
> entered on the form is the key to three other tables I need to create an
[quoted text clipped - 27 lines]
> > > another one? I only want to print one invoice at a time, but it will always
> > > be different.

Reply to this Message