Update a field in a form

[wellsfargouser]

Hey everyone, this is driving me crazy. I have a table which lists all the files users have on the server. This table is called risklist. It lists the pathname and size. The goal is to make a form that users can open up, filter for their user id and choose one of four options for each individual record.

I've built a query that runs based on a command button in the form that filters for the userid in a combo box on that same form(qryChooseUser) The combo box rowsource is all the distinct users (in a table). The filtered risklist table is then displayed in a subform on the main form and I want users to go to the last column and update the last field to one of these four options which are also stored in a table. And when they exit I want to save changes to the underlying table. I don't want them to be able to edit anything else.

currently i put a field in the risklist table called action which is a lookup field to the table with the four actions.I don't want there to be a lookup field in the table, i just want to update this field with the choice the user makes.

What's the most efficient way to do this?

[NeoPa]

You have (accidentally) posted this question in the Access Articles section. This is NOT an article.
I'm moving this to the main Access questions forum.

ADMIN.

[wellsfargouser]

You have (accidentally) posted this question in the Access Articles section. This is NOT an article.
I'm moving this to the main Access questions forum.

ADMIN.

sorry, and thank you

[NeoPa]

The ComboBox Wizard can take you through that.
Give it the details of what the options are and which field it should be bound to and it should set it up for you automatically. Have a play.

[NeoPa]

sorry, and thank you

No problem.
That's some quick-fire posting there :)

[wellsfargouser]

this wizard isn't helping. It just seems weird cause the field called action is a lookup table AND there's a combo box on the subform called action. Anyway, quick questions.

I want the default choice to be delete for each file and how do you allow a user to choose the same action on multiple files without doing it one by one?

[NeoPa]

this wizard isn't helping.
...

One thing at a time. Why is it not helping? What did you try?
I may be able to answer some of the other questions later with some clearer information from you.