A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

combo box to look up records won't work



 
 
Thread Tools Display Modes
  #1  
Old April 25th, 2008, 05:20 PM posted to microsoft.public.access.forms
Patrick Goodyear
external usenet poster
 
Posts: 1
Default combo box to look up records won't work

Hello,

I have a combo box on a form that I am trying to use to look up records
in a a table.

The combo box gets its value list from a field in the table that the
form is based on.

The combo box correctly shows the values. However, I cannot select a
value in the combo box. When I highlight the value I want, nothing happens.

The combo box is unbound, which I understand is okay.

Using the code builder with debugger, it seems like the combo box never
gets to it's After-Update event.

I have followed the method given in the Access help file, and two other
references for creating the combo box via the wizard with the same result.

I guess I have a form or combo box property set just wrong, but I can't
find which one, and I haven't found any reference to this problem, other
than the Access help file, which says I must have misspelled something
in the ControlSource property of the Combo box (but it's unbound!)

Any help is greatly appreciated.

Kind Regards,

Patrick
  #2  
Old April 25th, 2008, 06:41 PM posted to microsoft.public.access.forms
AKphidelt
external usenet poster
 
Posts: 591
Default combo box to look up records won't work

Typically this happens when you have the wrong column bound. I know from
experience that when you create a combobox through the wizard it typically
adds an unseen ID column as the bound column, although what you see is the
text that you want to see. If that's not the case, can you post your After
Update code?

Also if you are familiar with the VBE it is useful to use the Immediate
Window under view.

Then you can type out
?Forms!myform!mycontrol

And it will give you the actual value of that control that access reads. And
I'm sorry if you are beyond this point and im just preaching to the choir.

"Patrick Goodyear" wrote:

Hello,

I have a combo box on a form that I am trying to use to look up records
in a a table.

The combo box gets its value list from a field in the table that the
form is based on.

The combo box correctly shows the values. However, I cannot select a
value in the combo box. When I highlight the value I want, nothing happens.

The combo box is unbound, which I understand is okay.

Using the code builder with debugger, it seems like the combo box never
gets to it's After-Update event.

I have followed the method given in the Access help file, and two other
references for creating the combo box via the wizard with the same result.

I guess I have a form or combo box property set just wrong, but I can't
find which one, and I haven't found any reference to this problem, other
than the Access help file, which says I must have misspelled something
in the ControlSource property of the Combo box (but it's unbound!)

Any help is greatly appreciated.

Kind Regards,

Patrick

  #3  
Old May 4th, 2008, 02:15 PM posted to microsoft.public.access.forms
Lee Woodhouse
external usenet poster
 
Posts: 1
Default combo box to look up records won't work

I've just had exactly the same problem. I think this may be the solution your
after.

The form containing your combo box is set to 'Read Only' when opened,
overiding the AllowEdits setting in the forms properties. It needs to be set
to either 'Add' or 'Edit' mode when opened.

I suspect your form is opened using a macro (as opposed to the vb
DoCmd.Openform script). You need to edit the OpenForm setttings of your macro
and change to 'Edit'.




"Patrick Goodyear" wrote:

Hello,

I have a combo box on a form that I am trying to use to look up records
in a a table.

The combo box gets its value list from a field in the table that the
form is based on.

The combo box correctly shows the values. However, I cannot select a
value in the combo box. When I highlight the value I want, nothing happens.

The combo box is unbound, which I understand is okay.

Using the code builder with debugger, it seems like the combo box never
gets to it's After-Update event.

I have followed the method given in the Access help file, and two other
references for creating the combo box via the wizard with the same result.

I guess I have a form or combo box property set just wrong, but I can't
find which one, and I haven't found any reference to this problem, other
than the Access help file, which says I must have misspelled something
in the ControlSource property of the Combo box (but it's unbound!)

Any help is greatly appreciated.

Kind Regards,

Patrick

  #4  
Old May 5th, 2008, 02:04 AM posted to microsoft.public.access.forms
Linq Adams via AccessMonster.com
external usenet poster
 
Posts: 1,474
Default combo box to look up records won't work

when you create a combobox through the wizard it typically adds an unseen ID column as the bound column,

Not true on a form. On a form the column the wizard binds is the first field
selected in the combobox wizard. I believe you're referring to the wizard to
create a lookup field in a table.

As Lee stated, the usual reason (barring corruption) that a selection cannot
be made from a combobox is that, for some reason, the form itself is non-
editable. There are a number of things that can cause this, including the
form being based on a non-editable query, the form being called in a read-
only mode, or the form's AllowEdits Property being set to No.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200805/1

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:12 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.