Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / May 2004

Tip: Looking for answers? Try searching our database.

form based on query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Meg - 28 May 2004 20:29 GMT
I'm drawing a blank on how to do this.
I have a table (orderdetail)with order numbers and detail
info.  
I have a query (ordernumberquery) which has the order
numbers grouped so that I can use them in a combo box
without duplications.
I have a query (ordersummary) which totals various fields
in my order table by order.
I want a form with a combo box for ordernumberquery.  
When the user picks the order they want to look at, it
gives totalorder from the ordersummary.

Any and all help is greatly appreciated!
Thanks,
Meg
MacDermott - 29 May 2004 02:49 GMT
Make a form based on your OrderNumberQuery (I find names easier to read with
a few capital letters scattered in.)
Put a combobox on it -
   use the 3rd option on the combobox - go to a record based on your
choice.
   The wizard should walk you through the rest.

HTH
   - Turtle

> I'm drawing a blank on how to do this.
> I have a table (orderdetail)with order numbers and detail
[quoted text clipped - 11 lines]
> Thanks,
> Meg
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.