wirte value in another table based on form input

[Roy riggsjø]

i have two tables.
table 1
table 2

i have created a form for table 1. in this form i have a dropdown list of the records in table 2. so i wonder how i can flag one of the records in table 2 as selected when i choose this record in the dropdown list.
my idea is to use an field in table 2, "selected", and then write a code/VBA for Afterupdate on the dropdown list in the form which sets the actual "selected" field to True.

so my question is how to write a value to a table from a non linked form?

find record
edit record


Thank you!!

 

[MStef]

Hello Roy!

You don't need to put a FLAG on table2.
Simply in your drpodown list (combo box) show only the NON SELECTED records.
Look at "DemocomboWA2000.mdb" (attachment).
Look at tables, query, form, (VBA).
Open form and try. Adapt it in your mdb.