Entering multiple records in one form
 

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.


--
Newtonboy
------------------------------------------------------------------------
Newtonboy's Profile: http://www.excelforum.com/member.php...o&userid=29582
View this thread: http://www.excelforum.com/showthread...hreadid=560973

Entering multiple records in one form
 

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)

"Newtonboy" wrote in
message ...

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.


--
Newtonboy
------------------------------------------------------------------------
Newtonboy's Profile:
http://www.excelforum.com/member.php...o&userid=29582
View this thread: http://www.excelforum.com/showthread...hreadid=560973