Adding Multiple Entries To 1 Table

[sivega]

Hello,



Here's my situation. I have 1 table.

Person
Date of Event
Sponsor
Credit
Category

Sometimes a person will attend an event and recieve multiple credits in different categories. I have a form now that whenever does this does happen I can only enter 1 credit at a time, exit and reenter the form, and reenter all of the information for the same person but for a different credit.

Is there a way to be able to automatically enter another credit field on the form? I just don't want to have to keep renetering the same information all over again.....

Thank you!

[rzw0wr]

I don't think so. Nor easily anyway.
Another table for credits would solve your problem.

Dale

[June7]

Why are you limited to one record entry? You should have multiple related tables. Consider:

tblEvents
EventID
EventName
EventDate
EventSponsor

tblAttendees
AttendeeID
AttendeeName

tblCredits
EventID
AttendeeID
Credit
Category

Now use form/subform arrangement to enter data. Options:
1. main form bound to tblEvents, subform bound to tblCredits with combobox to select attendee
2. main form bound to tblAttendees, subform bound to tblCredits with combobox to select event

In either case, code behind the combobox can cause selected value to carry forward to next record by setting the DefaultValue property.
Private Sub comboboxname_BeforeUpdate(Cancel As Integer)
Me.comboboxname.DefaultValue = Me.comboboxname
End Sub

Also, if desired event or attendee not in the combobox list, use NotInList event to create new record. http://msdn.microsoft.com/en-us/libr.../ff845736.aspx