General discussion

Locked

Combo Box in Access

By highlander718 ·
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...

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by highlander718 In reply to Combo Box in Access

Point value changed by question poster.

Collapse -

by highlander718 In reply to Combo Box in Access

Point value changed by question poster.

Collapse -

by Mark W. Kaelin Editor In reply to Combo Box in Access

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.

Collapse -

by highlander718 In reply to

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.

Collapse -

by kwimbo In reply to Combo Box in Access

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.

Collapse -

by highlander718 In reply to

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.

Collapse -

by Mark W. Kaelin Editor In reply to Combo Box in Access

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.

Collapse -

by highlander718 In reply to

Why didn't I think consulting the knowledgebase :-) ? It must be the workload :-)

Collapse -

by highlander718 In reply to Combo Box in Access

This question was closed by the author

Back to Software Forum
9 total posts (Page 1 of 1)  

Related Discussions

Related Forums