Software

Ask something
Discussion Locked

Combo Box in Access

0 helpful
9 replies

by highlander718

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I give up on this, just doesn't want to work. Form based on a basic table, I select all the fields to show up, than want to repalce the first field with a combo box, so that I can quickly jump to the desired record. I have a database MADE BY ME !!! that does the same thing, I can't see a difference and I also don't remember how I did it in the first place, although I think it was a pretty straight forward thing.
Thing is : it's not working. I either scroll the combo box, but the other fields in the form do not refresh accordingly, or I get an error message when trying to select the first field (in the box), something about file not accessible, network connection might be lost (not the case).
I tried with a different database and the same things happens, I'm sure I'm missing something just don't know what...

9 replies

by Mark W. Kaelin

If I understand your question completely, I would answer this way:

1. Open the Design mode for your table.
2. Click on the field requiring a list/combo box
3. Click on the Lookup tab in the Properties box
4. Change the Text Box designation to List Box or Combo Box
5. Fill in the appropriate Row Source Type and Row Source information

Using the Northwind database I was able to create a Combo Box for the Cities field in the Customer table.

I hope that helps.

by highlander718

I did all that, didn't help. When I'm adding the field to the form, as combo-box, it's still not updating the other fields when selecting different values in the combo box.

by kwimbo

If your question is: Want to jump to a specific record displayable on the form and show all fields. Do this:-

1. click Combo box from tools bar, and click at the location you desire to place the combo searcher;
2. select 'Find a record on my form based on the value I selected in my combo box', next
3. select 2-3 fields, inclusing Key field; Next, Next, Next;
4. Ensure 'Remmember the value for later use' radio option is selected; Next;
5. Label your combo; Finish

This works well for me, try it.

by highlander718

I remember doing this in the first place and it worked. ONCE. After that I'm just getting a "Error accessing file. Network connection might be lost" message.
I repaired the mdb, I even reinstalled Office 2k, no good. I tried the same thing on a different machine (to make sure it's not a corrputed windows dll or something), as .mdb is on the network, no good. (Tried .mdb on local as well.)

And it's doing the same thing with a brand new database. Not sure what went wrong after it worked once.

by Mark W. Kaelin

So, if I am reading all of this information correctly, the problem is not that you don't know how to do it, but that when you do it ? it does not work. I did some poking around in the Microsoft Knowledge Base and came across several articles that may help you. You did not specify what version of Access you are using, but some or all of these may apply to your situation.

http://support.microsoft.com/default.aspx?scid=kb;en-us;304548

http://support.microsoft.com/default.aspx?scid=kb;en-us;326605

http://support.microsoft.com/default.aspx?scid=kb;en-us;836030

Have you installed Access Service Pack 3?

NOTE: You may have to fix the links for line breaks.

This discussion is closed to new replies.