contant fields

T

Tom

Hi,

I have an input form to record invoices.

I would like to input date and vendor once (per invoice) and then the rest
of the information.

the trick is that I need the date and the vendor to apper in every record.

like this:

Date, vendor, product, price, quantity.

I thought to put the last 3 on a subform, it didnt work.


Any suggesstions?

Thank you very much for your time.


Tom
 
G

Guest

Use a separate form. When the data is updated then open the next form for
data entry leaving the first form open. The second form can default the text
boxes from the first form using [Forms]![FirstFormName]![DateTextBox]
and [Forms]![FirstFormName]![VendorTextBox]
 
T

Tom

Karl,
Thank you so much, work like magic.

Tom

KARL DEWEY said:
Use a separate form. When the data is updated then open the next form for
data entry leaving the first form open. The second form can default the
text
boxes from the first form using [Forms]![FirstFormName]![DateTextBox]
and [Forms]![FirstFormName]![VendorTextBox]

Tom said:
Hi,

I have an input form to record invoices.

I would like to input date and vendor once (per invoice) and then the
rest
of the information.

the trick is that I need the date and the vendor to apper in every
record.

like this:

Date, vendor, product, price, quantity.

I thought to put the last 3 on a subform, it didnt work.


Any suggesstions?

Thank you very much for your time.


Tom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top