Entering multiple records in one form

N

Newtonboy

I have my data in the following format:

Date ! Unit ! Account Code ! Product Code ! Description ! Debit !
Credit !

I enter data using a form.

As of now, for each entry i have to type in the date & unit every time.
Can't i have a system where for the same date and unit i update say 5
records and excel updates the Account code, product code etc. keeping
teh date and unit same ?

Pls Help.
 
B

Bob Phillips

That is just a design issue.

Have some boxes for the static data, put that in a frame say, then create
another frame with 5 instances of the variable data. You will then just
create the database from that input.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top