List box and command button to display results in new form

I am missing something.  In Access 2003 I never had this problem, but now I 
am using 2007.

In a form I would create a list box that would display one column from a 
table.  Then I would create a command button using the button wizard that 
would then open a form which would only display certain records, then I would 
link the list box to the appropriate column in the table and it would display 
the correct results according to what was selected in the list box.  

In 2007 I can not link the listbox to the appropriate column in the table in 
the wizard.  Am I missing something when I create the list box and not 
identifing it appropriately?

Thanks
0
Utf
11/29/2007 10:11:06 PM
access.forms 6864 articles. 2 followers. Follow

0 Replies
930 Views

Similar Articles

[PageSpeed] 7

Reply:

Similar Artilces:

Any ways of exporting an Invoice Form in SOP to either Word or Exc
Hi Is there any way to export an Invoice Form (Blank, Short, Long) that is printed from SOP to either Word or Excel? I know that Smartlist provides you the ability to do this, and you can always send the form to text file (Send to) convert to Excel, but is there a way to do this via Excel the easiest way or Word? Thanks! You want to print an invoice to an Excel format, is that correct? If so, I'm not aware of any direct method. There might be a third party product that will accomplish this. "Bryan Hipolito" wrote: > Hi > > Is there any way to export an...

Customizing Activities\History LIst
Is there a way to add a date to Activities' History list? It would be nice to know when each activity happened. Thanks, Troy Troy, no way currently, although Microsoft has mentioned it might be an option in version 2.0 (nothing is guaranteed!) A few ISVs have custom products that do it... www.salentica.com www.c360.com Dave "Troy" <anonymous@discussions.microsoft.com> wrote in message news:af6b01c436bd$ce671f00$a001280a@phx.gbl... > Is there a way to add a date to Activities' History > list? It would be nice to know when each activity > happened. >...

Using TEXT and &TEXT
I'm familiar with the TEXT function, but sometimes a number will display incorrectly when I format numbers to display with a comma if 4 digits or more. For example, TEXT(F1,"0,0") will display 10 thru 999 correctly and displays 1000 correctly as 1,000, but displays 1 thru 9 as 01, 02, etc. Also wondering how to format part of a TEXT formula to underline, and bold or color selected words. Maybe you want: =text(f1,"#,###") or =text(f1,"#,##0") If this doesn't help, maybe you could post the values and what you want to see for a few exa...

Better to "nest" or use multi-level list?
I'm in the process of creating/defining a style(s) for a list that will be numbered in "level 1" and have indented bullets in "level 2." For such a list is it better to define a multi-level list style and linked paragraph styles? Or use one's already defined numbered list and use one of the Word's pre-defined bullet lists when needed for the second level? As part of this question, is is preferable not to have a style "nested" within another style or doesn't it matter? Thank you. -- Norm Hi Norm: I'm not sure why yo...

Distribution List Changes
Hi All, I have a mail enabled distribution list with four users. Only those users plus the Administrator have rights on this group. Yet a seperate user is able to add / edit or remove users to this group even though they do not belong to this group. The user does not even have admin rights and is able to make changes. Let me know of any options I can try. Thanks Waynear wrote: > Hi All, > > I have a mail enabled distribution list with four users. Only those > users plus the Administrator have rights on this group. > > Yet a seperate user is able to add / edit or remov...

Sound shows on custom Annimation list yet no sound heard
When the PP Presentation is saved as a show,some slides have sound and some do not. All sound came from the same folder. Also, when playing the slides while in PPPresentation, swome have sound and some do not despite all being indicated on custom annimation lisy and all startin "after previous." Thanks! Often when one sound plays but another doesn't, it's an issue of the length of the file path. What's the file path to your music? Is it really long? If so, the longer-named songs might just be hitting the length limit. -- Echo [MS PPT MVP] http://www.ec...

Control Button help needed
In the microsoft template database "Classroom"/ Classes form there is a command button that will open another form (Students) on a specific record in the subform. I can't figure out how to do this. Can anyone out there help me? The code behind the button is using the OpenForm method and is passing the ID of the record to open to as part of the "WHERE" argument. Look up OpenForm method (or action to see the macro version) and review the arguments. "Obeide115654" <Obeide115654@discussions.microsoft.com> wrote in message news:325A53B7-7553-40F0...

after migrating to a new domain no free/busy info
Hey, After we migrated users from one domain to another we have no free/busy information for any old calendar events. The new domain was not a child domain of the old one or vice versa. Both exchange servers are 2003. Would this fall under the same resolution when this issue happens after migrating from 5.5 to 2000? Thanks for any help. "Thurman" <Thurman@discussions.microsoft.com> wrote: >After we migrated users from one domain to another we have no free/busy >information for any old calendar events. If they occur in the past, why would that matter? >The n...

Drop Down List and Check Box
Hi...I was search for this topic but don`t found the solve...Anyway I have a drop down list like this [image: http://www.geocities.com/augurtrade/excel_checkbox.txt] and this [image: http://www.geocities.com/augurtrade/excel_checkbox2.txt] ok my questions is what is (Blanks) and (NonBlanks)...? Is it possible for me to see only all the check box that was checked or vice versa...??? How to make a total below the checkbox i mean when someone check the check box, a total number appear below the last check box [image: http://www.geocities.com/augurtrade/excel_checkbox3.txt] [image: http://www.g...

how reliable is the "Who has you in their contact list" list?
Because someone who I think has recently (within the last week) deleted me is still on this list (I don't think she blocked me), but when I check who deleted me on blockstatus.com, he shows up. could it be it's not updated? which of the two would be more reliable? -- maykk Greetings, Do not use these websites, they will steal your identity and sell it. You should change your password immediately. That said, in general, the "who has..." list within Messenger is accurate. There have been instances over the last six-months or so where the list (and m...

Check Box to display records with completed status only
Hi, I have a query whereby a record is lablelled complete if the "Completed date" field has a date in it, otherwise it is blank. I want to check box on a form when ticked, to display a report with completed records only. Can anyone help? Thanks, B/ On your form, you have a command button to open the report, and a check box named (say) chkCompleteOnly. If the check box is checked, you want to open the report to show only the records that have a date in the [Completed date] field. The event procedure for the command button's Click event would look like this: Priv...

Selecting from contacts list
I have all my contacts in the Contacts List and I want to delete all those with a common extension i.e. all those who have email addresses @hotmail. I am using Outlook 2007 Can you do a search or advanced search which will show the contact you want to delete? You should be able to highlight & delete them from the results. "GrahamC" <GrahamC@discussions.microsoft.com> wrote in message news:6AC1880D-9632-4ED9-BAE2-7083690B9FA7@microsoft.com... > I have all my contacts in the Contacts List and I want to delete all those > with a common extension i.e. all t...

Script to list access right
Hi I am trying to find any script which would generate list of login users with certain access level (select, write etc.) at one particular database. Is there something like that? Thanks. Justin ...

Filters, Buttons, Queries, oh my!
i have a main form with a subform. the main form and the subform are unrelated. the subform is based on a query that lists a load of stuff and does some calcs that use numbers on the main form with numbers from the subform. this all works great. i have some buttons that allow me to cause a filter to be applied to the subform based on the code that i put in the buttons on click event. there are 6 buttons that turn on a specific filter and 6 other buttons that turn off the filter. i know i probably should have used toggle buttons, but as i am still learning i wanted to make it easy on my...

vb6 run time error 5 when Outlook 2007 Explorer object displayed
hi all I have a vb6 program which integrates with MS Outlook and was working fine until the client upgraded their PC's - the OS stayed at XP Pro but Office was upgraded from 2003 to 2007. The app is now throwing a runtime error 5 "invalid procedure call or argument". This is difficult for me to debug as I my dev machine is W2K so I cannot install Office 2007 on it. But as far as I can tell the error is occurring when the code gets to the line myExplorer.Display - this is in response to the user double clicking a calendar item in Outlook. Just wondering is...

a list of lists
currently i use CArray to keep track of a list of objects, but I don't know MFC classes well enough to keep track of a list of lists. I'd appreciate some suggestions "wanwan" <ericwan78@yahoo.com> ha scritto nel messaggio news:1187535523.924671.143350@j4g2000prf.googlegroups.com... > currently i use CArray to keep track of a list of objects, but I don't > know MFC classes well enough to keep track of a list of lists. I'd > appreciate some suggestions You might want to embedd your list based on CArray into a class (e.g. CListOfSomething), and then ...

Smart List export to Excel #2
Hi, We are using Dynamics 9.0 and Office 2003. When we try to do a Smart List export to Excel, we keep getting an "Exception_Class_Object_Exception" that references varying object errors, such as 'Cells' or 'Value'; the object errors will change each time we try an export. As a workaround, I've found that closing Excel before doing the export allows the export to complete successfully. However, that solution isn't acceptable, as our Dynamics users would like to be able to work in Excel, doing other tasks, while the export is processing. Does anyone...

List of different values in data area
Hi excel specialists, How Can I automatically get the list of different values from the dat area and to find out their frequence? INDIVIDUALLY MEASURED VALUES: 3,5 4 3,5 4 3 3,5 4 4 3 3,5 4 3 3,5 3 3 3,5 4 4 Thanks for your help in advance. Balcovja -- balcovj ----------------------------------------------------------------------- balcovja's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2623 View this thread: http://www.excelforum.com/showthread.php?threadid=39572 Take a look at FREQUENCY in Hep -- HTH RP (remove nothere from the email address if m...

Can data in one text box automatically appear in another?
I am trying to design a form in Publisher, and would like to link text boxes so that data entered in one will automatically appear in another on the same page. Is this feasible? How will this form be used? "G.O.G." <G.O.G.@discussions.microsoft.com> wrote in message = news:E4C951DF-7D4F-4FC1-8F6B-2C0B4EB8882A@microsoft.com... > I am trying to design a form in Publisher, and would like to link text = boxes=20 > so that data entered in one will automatically appear in another on = the same=20 > page. Is this feasible? Maybe with some programming... -- Mary Saue...

Global Address List and Handhelds
We use Ipaqs throughout the company, and I was wondering if there is anyway to have exchange add the GAL to the outlook contacts on the workstation, so that when they sync up, they will retrieve the Global Address List? In news:%23TkYtT0$GHA.3560@TK2MSFTNGP04.phx.gbl, Flip <phil.atkinson@beltek.com> typed: > We use Ipaqs throughout the company, and I was wondering if there is > anyway to have exchange add the GAL to the outlook contacts on the > workstation, so that when they sync up, they will retrieve the Global > Address List? No (and this wouldn't really be an ...

Fields in items list-- add/delete
Hai, I am using RMS version 1.2. In Stores Operations Manager it displays list of items when click on Database-->Items. It displays only five columns. Now i need to add / delete some fields in this list. Is it possible to add or delete the fields? if yes how can i add the fields? Thanks in advance, Nagendra On Wed, 27 Apr 2005 01:22:02 -0700, "Nagendra" <Nagendra@discussions.microsoft.com> wrote: >Is it possible to add or delete the fields? if yes how can i add the fields? I don't think so antonio ...

Formatting a pivot worksheet to display a string at the end!
Hi there, I have created several worksheets using the 'Show Pages' function, but now need to add a bit of blurb underneath each of the pivot tables. I was thinking of doing this in the Page Footer, but this will be displayed on every page - and some worksheets will span several pages. Can anyone tell me if there is an easy and quick way of adding some text to the end of the pivot tables in every worksheet (there are 50 worksheets!) thanks in advance, Matt -- matpj ------------------------------------------------------------------------ matpj's Profile: http://www.excelforum...

Tip: How to display picklist values using radio buttons instead of dropdown
I discovered this by chance. I hope it helps someone. I was changing a set of Yes/No radio buttons (bit type) into Yes/No/ Unknown dropdown (picklist only allows dropdown display). I had to remove the fields from the form, publish it, THEN delete the attributes and finally create them again with the new data type, add them to the form, and publish again. Basically, normal. The trick I stumbled into is: When you delete the attributes, DO NOT SAVE YET. Create the new attribute with the same name with the new data type of picklist while the window is still open. Then add to form and publish as ...

remove small list from large list
I have two mail lists on excel. The first has 16,000 names, the second has about 6,000. I need to remove the 6,000 from the 16,000 as they all appear in the big list as well. How do I extract those 6,000 entries from the larger list? My expected result is a mailing list with 10,000 names. Chip Pearson has some techniques at: http://www.cpearson.com/excel/duplicat.htm Howie J. wrote: > > I have two mail lists on excel. The first has 16,000 names, the second has > about 6,000. I need to remove the 6,000 from the 16,000 as they all appear > in the big list as well. How do ...

Jpeg's appearing as black boxes...
Version: 2008 I am new to using Word for Mac - having recently transferred from a PC. I am finding that some (not all) some documents are displaying the jpeg's on them as black boxes. Instead of the image the entire are is just black and prints this way also. The image displays correctly in the finder, but once the document is full size, the image is a black box. <br> Help please! How do I get my images back? <br><br>Thanks <br><br>Amber Hi Britamy: Chances are they are CMYK JPEGs. Word (or any other Microsoft Office application) can't handle CM...