S
soonerj
Ok, I have a form that has a drop-down menu for account numbers. When
you select one, the customer and address fields populate. Then there
are several fields that the user fills in: Month, Amount of Bill, Type
of Service Completed, and Date Received.
Let's say I select account number 001. The name and address comes up
as John Doe, 123 any street, anytown, HI.
I then type in January, $12.00, Rabies Vaccine, 02-12-06.
I move on to the next record and it is for the same account. I choose
account 001 and the rest populates as usual. However, rather than
taking me to a new record it takes me back to the first record with
that account number.
What can I do so I can have multiple records with the same account
number? I'd need to input monthly data for each account without losing
any old data.
I'm an obvious beginner to Access so you'll have to reply like you're
talking to an idiot.
you select one, the customer and address fields populate. Then there
are several fields that the user fills in: Month, Amount of Bill, Type
of Service Completed, and Date Received.
Let's say I select account number 001. The name and address comes up
as John Doe, 123 any street, anytown, HI.
I then type in January, $12.00, Rabies Vaccine, 02-12-06.
I move on to the next record and it is for the same account. I choose
account 001 and the rest populates as usual. However, rather than
taking me to a new record it takes me back to the first record with
that account number.
What can I do so I can have multiple records with the same account
number? I'd need to input monthly data for each account without losing
any old data.
I'm an obvious beginner to Access so you'll have to reply like you're
talking to an idiot.