|
| 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
February 28th, 2007, 12:17 AM
posted to microsoft.public.access.queries
|
|||
|
|||
Using a query to populate a search form
I have a query that i want to use to look up parts by part number, every
part has 20 related field in this query, i want to use a textbox to type the part number and use a command button to execute the search that will then populate the remaining fields, how should this be done 
|
|
#2
February 28th, 2007, 12:55 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Using a query to populate a search form
Use a form.
Add a combo box that lists all parts. Bind the form to a query that returns the part-related fields, but only for the part selected in the combo box. In the AfterUpdate event of the combo box, requery the form: Me.Requery Now you have a form that lets the user select a part and see the part-related field values. Regards Jeff Boyce Microsoft Office/Access MVP "mikeinohio" wrote in message ... I have a query that i want to use to look up parts by part number, every part has 20 related field in this query, i want to use a textbox to type the part number and use a command button to execute the search that will then populate the remaining fields, how should this be done
|
|
#3
February 28th, 2007, 04:36 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Using a query to populate a search form
Thanks Jeff, the part numbers either start with a number or a such as 1,2,3,
etc... or they start with a "#" then numbers or letters, will this still work? "Jeff Boyce" wrote: Use a form. Add a combo box that lists all parts. Bind the form to a query that returns the part-related fields, but only for the part selected in the combo box. In the AfterUpdate event of the combo box, requery the form: Me.Requery Now you have a form that lets the user select a part and see the part-related field values. Regards Jeff Boyce Microsoft Office/Access MVP "mikeinohio" wrote in message ... I have a query that i want to use to look up parts by part number, every part has 20 related field in this query, i want to use a textbox to type the part number and use a command button to execute the search that will then populate the remaining fields, how should this be done
|
|
#4
February 28th, 2007, 06:20 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Using a query to populate a search form
You can use whatever you want as the row source in a combo box...
What happens when you try it? Regards Jeff Boyce Microsoft Office/Access MVP "mikeinohio" wrote in message ... Thanks Jeff, the part numbers either start with a number or a such as 1,2,3, etc... or they start with a "#" then numbers or letters, will this still work? "Jeff Boyce" wrote: Use a form. Add a combo box that lists all parts. Bind the form to a query that returns the part-related fields, but only for the part selected in the combo box. In the AfterUpdate event of the combo box, requery the form: Me.Requery Now you have a form that lets the user select a part and see the part-related field values. Regards Jeff Boyce Microsoft Office/Access MVP "mikeinohio" wrote in message ... I have a query that i want to use to look up parts by part number, every part has 20 related field in this query, i want to use a textbox to type the part number and use a command button to execute the search that will then populate the remaining fields, how should this be done
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
