rewriting a table row from a form

[Guest]

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.

 

[Nikos Yannacopoulos]

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

 

[Guest]

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.
--
kati h

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
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.

 

[Larry Daugherty]

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
--
-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
invoice. Any ideas? Maybe there is a better way to do this.
--
kati h

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
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.