By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,460 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

Update a field in a form

P: 3
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?
Oct 29 '07 #1
Share this Question
Share on Google+
6 Replies


NeoPa
Expert Mod 15k+
P: 31,263
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.
Oct 29 '07 #2

P: 3
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
Oct 29 '07 #3

NeoPa
Expert Mod 15k+
P: 31,263
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.
Oct 29 '07 #4

NeoPa
Expert Mod 15k+
P: 31,263
sorry, and thank you
No problem.
That's some quick-fire posting there :)
Oct 29 '07 #5

P: 3
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?
Oct 29 '07 #6

NeoPa
Expert Mod 15k+
P: 31,263
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.
Oct 29 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.