How to "add more" option in Forms in Access

[srp189]

I am designing a form in which i want to entry people present ..it is not already defined.
In form on one option available i.e.

People Present Category Date
abc z+ 08-12-2016

Now if one than one people are there. how to add here...just a drop option like add more shows in "people present" automatically category and date gets a new row.
Is it possible...if yes please guide and also what this option is called.

[Bulzie]

Not following what you are asking. Can you explain it another way.

[srp189]

I want to create form like this..
If i want to add more data under same header ...a button to be provide like "add more"...
Now question is is it possible in access and if yes how to do...?

[alansidman]

What are the fields in the table that this form is bound to? How is your db designed? ie. What tables do you have and the relationship between them as it relates to this issue. If properly designed then it is probably a case for using a form and sub form. But without further information it is difficult to give you a good answer.

[srp189]

I want to create form like this..
If i want to add more data under same header ...a button to be provide like "add more"...
Now question is is it possible in access and if yes how to do...?

[Bulzie]

This might be one way but not having all information or knowing what you want, taking a guess.

3 Tables, 2 Forms:

tblEvents:
EventID: Autonumber
EventName: Text
EventDate: DateTime

tblAttendance
AttendanceID: Autonumber
EventID: Number - this will link to the Event record.
EmpID: Number - this will link to the Employee record

tblEmployee:
EmpID: Autonumber or an employeiD or that Designation field if that is unique to an employee
EmpName: text

tblEvents links to tblAttendance by EventID (1 to many)
tblEmployee links to tblAttendance by EmpID (1 to many)

Create frmEvents based on tblEvents, add EventName, EventDate at top.
Create frmAttendance based on tblAttendance, add EmpName, EmpDesignation fields. For EmpName(create combo box to select employee based on EmpID), (in subform frmAttendance properties for LinkMaster and LinkChild enter EventID).

To answer your question above, you can add a button in the frmAttandance subform to go to a new record which sounds like what you want to do. This should get you started.

[orange]

I agree with Bulzie that your requirement is unclear. There is an old adage with programmers/programming --If you can't describe it clearly, nobody can design/build it.
So, I suggest that instead of showing us HOW you have created a Form, you describe is 5-6 lines of plain, simple English (no database jargon) WHAT you are trying to accomplish.

It is not efficient for readers to guess at your requirements. For yourself and for readers, take the time to clearly describe your requirement, it will streamline things.

Good luck.