How to save selected value in a listbox

[Cedarguy]

I have a form with a table and 2 list boxes.

The table is a child to the 2 tables the listboxes pertain to.

Selecting a value in the listboxes populates the selected fields in the table on the form.

It all works as expected EXCEPT

After the record is added to the table and the next blank one comes up, the values in the listboxes are no longer selected. I need to reuse the selected values on multiple records.

Is there a way Access can accommodate this?

Thanks

 

[Pat Hartman]

If many rows have the same value, it is likely that the "duplicate" fields need to be moved to the parent table or perhaps an intermediate table needs to be created.

there are several interface shortcuts that will enable you to copy values from the "previous" row and no coding is required. these same shortcuts also work in Excel so if you are familiar with Excel, you may know some already. The most common one is cntl-quote to copy the value from the same field in the previous row. Search for Access keyboard shortcuts for a complete list.