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  

What is the extra field added with a combo or list box



 
 
Thread Tools Display Modes
  #1  
Old May 20th, 2010, 02:22 PM posted to microsoft.public.access.forms
Corey
external usenet poster
 
Posts: 48
Default What is the extra field added with a combo or list box

I posted this question once already but I think I forgot to specify a
discussion group, so here it is again, sorry if it's a duplicate.

Anyway... some of the time but not always, when I add an unbound combo or
list box control to a form, Access adds a corresponding column to the data
sheet portion of the form. Usually my reason for the control is to look up
and go to entered values. The extra field holds the value that is selected
in the control, but doesn't seem to do anything else. If I hide the column
the control will no longer do the search. What is this extra column and what
can I do differently to get rid of it? Any help would really be appreciated,
thanks!
  #2  
Old May 20th, 2010, 03:16 PM posted to microsoft.public.access.forms
Golfinray
external usenet poster
 
Posts: 1,597
Default What is the extra field added with a combo or list box

If I am understanding your question correctly, that extra column is your key
field. Searches on primary keys are always faster because they are always
indexed.
--
Milton Purdy
ACCESS
State of Arkansas


"Corey" wrote:

I posted this question once already but I think I forgot to specify a
discussion group, so here it is again, sorry if it's a duplicate.

Anyway... some of the time but not always, when I add an unbound combo or
list box control to a form, Access adds a corresponding column to the data
sheet portion of the form. Usually my reason for the control is to look up
and go to entered values. The extra field holds the value that is selected
in the control, but doesn't seem to do anything else. If I hide the column
the control will no longer do the search. What is this extra column and what
can I do differently to get rid of it? Any help would really be appreciated,
thanks!

  #3  
Old May 20th, 2010, 04:09 PM posted to microsoft.public.access.forms
Adrian C
external usenet poster
 
Posts: 4
Default What is the extra field added with a combo or list box

On 20/05/2010 14:22, Corey wrote:
I posted this question once already but I think I forgot to specify a
discussion group, so here it is again, sorry if it's a duplicate.

Anyway... some of the time but not always, when I add an unbound combo or
list box control to a form, Access adds a corresponding column to the data
sheet portion of the form. Usually my reason for the control is to look up
and go to entered values. The extra field holds the value that is selected
in the control, but doesn't seem to do anything else. If I hide the column
the control will no longer do the search. What is this extra column and what
can I do differently to get rid of it?


It's unbound, so data entered there (either typed direct or from the
dropdown) only exists in the form's data entry buffer. If you flip
between form view and datasheet view, you'll notice this control as an
extra column added alongside other fields (bound and unbound). However
as an unbound field, the value currently entered in it will be shown all
the way down the datasheet as long as there are table records to display.

However, hiding this field in datasheet view still allows VBA
(beforeupdate & afterupdate) events to work for me for the form control
in Access 2003. How is the search action triggered in your code?

--
Adrian C
 




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 10:18 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.