I have a form that gives me a basic rundown of computers at my facility. I have a field called "Computer Description" which lists the user or location name of that computer. On the form the "Computer Description" is setup as a combo box so that I can select the computer and it brings the information relating to that computer to my form. What I would like to do is be able to update information in the combo box, for example let's say that a drop down choice is Joe S. and I would like to change it to Joe Shmoe. What is the best way to do this, any help would be appreciated.
Combo Box
- Thread starter Anarch
- Start date
David R
I know a few things...
- Local time
- Today, 12:12
- Joined
- Oct 23, 2001
- Messages
- 2,632
You can put a button next to the combo box to open a small popup form to that user's entry in the other table, and change it there. Make sure you protect it somehow if other people will have access to the form.
Look up the Access help on 'synchronize records between forms', I believe.
HTH,
David R
Look up the Access help on 'synchronize records between forms', I believe.
HTH,
David R
So I gather there is no way to edit the combo box selections on the fly so to speak? Should I use a query to populate the combo box choices? What I really wanted to do was edit the selection I make if I need to. I am using the table that holds my data as a source to populate the combo box...maybe I just aint explaining this correctly. BTW thanks for the prompt posting in regards to helping me.
David R
I know a few things...
- Local time
- Today, 12:12
- Joined
- Oct 23, 2001
- Messages
- 2,632
No, I can't think of any way to use a combo box BOTH as a lookup field, and allow the user to edit the values in the combo box.
Maybe someone smarter than I can.
There is one topic on the Support Center you might try, using a bound control to search: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q136123 (for Acc95/97) or Q210239 for Acc2k.
HTH,
David R
Maybe someone smarter than I can.
There is one topic on the Support Center you might try, using a bound control to search: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q136123 (for Acc95/97) or Q210239 for Acc2k.
HTH,
David R
David R
I know a few things...
- Local time
- Today, 12:12
- Joined
- Oct 23, 2001
- Messages
- 2,632
Here's why I don't think this is feasible:
Say you go into Joe S.'s record, and you want to change his name in the combo box field to Joe Schmoe, so you can enter Joe Smith.
How is Access to know that you are not looking for a completely separate record named Joe Schmoe? I don't know that it can. That's why I suggested a separate form, perhaps only one your database administrators can open, for changing people's names, editing this sort of data.
Or what I have in my database is one (unbound) field to lookup people, and the actual field it's looking at shows up on the form as well. So if I get to record 23RJAN and realize the name is James, not Janes, I can change the ParticipantID to 23RJAM in the bound field. However I have that field locked unless you double-click on it, and there's very few people actually in our database. The more users, the greater the chance for mischief/simple human error.
HTH,
David R
Say you go into Joe S.'s record, and you want to change his name in the combo box field to Joe Schmoe, so you can enter Joe Smith.
How is Access to know that you are not looking for a completely separate record named Joe Schmoe? I don't know that it can. That's why I suggested a separate form, perhaps only one your database administrators can open, for changing people's names, editing this sort of data.
Or what I have in my database is one (unbound) field to lookup people, and the actual field it's looking at shows up on the form as well. So if I get to record 23RJAN and realize the name is James, not Janes, I can change the ParticipantID to 23RJAM in the bound field. However I have that field locked unless you double-click on it, and there's very few people actually in our database. The more users, the greater the chance for mischief/simple human error.
HTH,
David R
Similar threads
