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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|