Access Newbie Question

[negative_creep]

I am new to Access and I need some help with this simple question. I have a table with a list of employees and another table where I will be storing the records of said employees (safety infractions, truancy, etc.). I have created a form to enter in the employee record data with a combo box that drops down to list the employees (from employee_list table). The combo box displays the employees correctly, but I am having trouble figuring out what to put in the control source property. What do I put in here to save this selection into a table?

Thanks,

[pbaldy]

I would expect the form to be bound (record source) to the infractions table, and the combo to be bound (control source) to the employee ID field in that table. Thus the control source of the combo would be the field name.

[negative_creep]

I am so glad I posted here as I am already making progress. I didn't know about the record source property. This seems to be working OK now with the exception of it constantly overwriting record #1 during a save operation. How can I same each record to a new ID #?

[pbaldy]

A form by default shows all records in the table and opens to the first one. Sounds like you want to change the Data Entry property of the form to Yes.

[Micron]

I would expect the form to be bound (record source) to the infractions table, and the combo to be bound (control source) to the employee ID field in that table. Thus the control source of the combo would be the field name.

Doesn't that mean that only employees with an infraction will appear in the combo list? Shouldn't the employee list come from the employees table?

nc; if you bind a combo to a field and play with its selections then move off the record or close the form, any changes become the new value for that field in the affected record. If you don't want that, you either have to understand that you must not alter the selection unless you are performing an edit, or don't bind the combo to the field. This is common practice for combos that provide lookup lists or perform filtering for form records. In the latter case, you have to write the value to the table by macro or code.

[pbaldy]

Doesn't that mean that only employees with an infraction will appear in the combo list? Shouldn't the employee list come from the employees table?

No, that's determined by the row source property, as I'm sure you're aware. The OP already has that working: "the combo box displays the employees correctly".

[Micron]

I guess I misunderstood your comment.

form to be bound (record source) to the infractions table, and the combo to be bound (control source) to the employee ID field in that table

which I took to be a source different from

I have a table with a list of employees

[negative_creep]

A form by default shows all records in the table and opens to the first one. Sounds like you want to change the Data Entry property of the form to Yes.

I have made this change, but still having the same issues. Would try to save multiple instances of the same employee name have anything to do with it?

[orange]

NC, Tell us about the table(s) you have now. It would be helpful to readers if you gave us a 30,000 ft overview of the proposed "business" that this database will support. The types of infractions; any queries or reports you need.
Welcome to the forum and good luck with your project.

[negative_creep]

NC, Tell us about the table(s) you have now. It would be helpful to readers if you gave us a 30,000 ft overview of the proposed "business" that this database will support. The types of infractions; any queries or reports you need.
Welcome to the forum and good luck with your project.

Table One titled "Employee_List" This table has ID numbers and employee names. I will draw from this employee list to populate a combo box on the input form
Table Two titled "Records" This table will store the employee name, date of incident, and some other data that will be entered by the user on the input form

[pbaldy]

I have made this change, but still having the same issues. Would try to save multiple instances of the same employee name have anything to do with it?

Can you attach the db here?

[negative_creep]

Can you attach the db here?

The file size is too big, and when I zip/compress it, the forum doesn't like the file type.

How can I get it attached?

[orange]

see https://www.accessforums.net/showthread.php?t=70301

[negative_creep]

see https://www.accessforums.net/showthread.php?t=70301

Following this process, my file size is still too large to upload. Its capped at 500k

[pbaldy]

Did you zip it? The limit for zip files is 2MB.