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  

Loopup Box



 
 
Thread Tools Display Modes
  #1  
Old April 15th, 2010, 06:13 PM posted to microsoft.public.access.forms
Brian T
external usenet poster
 
Posts: 45
Default Loopup Box

Hello all,

I have a form that has a combo box for Project Numbers (these are text since
they are alphanumeric) and I would like to automatically fill in the Project
Name. I am using Access 2007. Any embedded macro help would be great.

Thanks,
  #2  
Old April 15th, 2010, 07:13 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Loopup Box

On Thu, 15 Apr 2010 10:13:02 -0700, Brian T
wrote:

Hello all,

I have a form that has a combo box for Project Numbers (these are text since
they are alphanumeric) and I would like to automatically fill in the Project
Name. I am using Access 2007. Any embedded macro help would be great.

Thanks,


WHERE do you want to "fill it in"? You can certainly *display* it on the form;
just include the project name in the combo box's Row Source query, set the
Column Count large enough to include it, and put a textbox with a control
source like

=comboboxname.Column(n)

where n is the zero-based index of the column containing the name.

If you want to store the project name redundantly in a table other than the
table of projects... well, don't, unless you have some VERY good reason. If
you have such a reason please explain.
--

John W. Vinson [MVP]
  #3  
Old April 16th, 2010, 03:24 PM posted to microsoft.public.access.forms
Brian T
external usenet poster
 
Posts: 45
Default Loopup Box

John,

I am using the form to create a report (which is a form letter) and I want
the project name to show up in the report and I can't fiugre out how to get
it in there.

"John W. Vinson" wrote:

On Thu, 15 Apr 2010 10:13:02 -0700, Brian T
wrote:

Hello all,

I have a form that has a combo box for Project Numbers (these are text since
they are alphanumeric) and I would like to automatically fill in the Project
Name. I am using Access 2007. Any embedded macro help would be great.

Thanks,


WHERE do you want to "fill it in"? You can certainly *display* it on the form;
just include the project name in the combo box's Row Source query, set the
Column Count large enough to include it, and put a textbox with a control
source like

=comboboxname.Column(n)

where n is the zero-based index of the column containing the name.

If you want to store the project name redundantly in a table other than the
table of projects... well, don't, unless you have some VERY good reason. If
you have such a reason please explain.
--

John W. Vinson [MVP]
.

  #4  
Old April 16th, 2010, 05:20 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Loopup Box

On Fri, 16 Apr 2010 07:24:03 -0700, Brian T
wrote:

John,

I am using the form to create a report (which is a form letter) and I want
the project name to show up in the report and I can't fiugre out how to get
it in there.


Base the Report, not on your table, but on a Query joining your table to the
Projects table. Include the ProjectName from the Projects table on the report.
If you're assuming that a report must be based on a table containing all the
fields to be printed, revise that assumption - the vast bulk of reports will
be based on multitable queries.
--

John W. Vinson [MVP]
 




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 12:08 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.