contant fields

  • Thread starter Thread starter Tom
  • Start date Start date
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
 
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]
 
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
Click to expand...
Click to expand...
 
Back
Top