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
|
|||
|
|||
combo with auto fill Access 2000
I would like to have a form with a combo box where I can select a part number
and after I select that part number to have the rest of the form fill in. |
#2
|
|||
|
|||
combo with auto fill Access 2000
Create a form with the fields you want to display. Create a query that
returns all records for the form. On the form, add an unbound combobox that lists part numbers. The Header is a good location. Modify the query to look at the form's combobox as a selection criterion for the part number field. This will look something like: Forms!YourFormName!cboYourComboboxName In the combobox's AfterUpdate event, add something like: Me.Requery (this will cause the form to recheck its source, the query, which uses the combobox selection to return a single record) It that what you are trying to do? Regards Jeff Boyce Microsoft Office/Access MVP "uuhhgg" wrote in message ... I would like to have a form with a combo box where I can select a part number and after I select that part number to have the rest of the form fill in. |
#3
|
|||
|
|||
combo with auto fill Access 2000
One way you could do this would be to have some/all of your additional
fields in your combo box row source (like PartNo, Desc, Cost, Markup, Sell Price, etc.) and in the AfterUpdate event of the combo box, you could then fill your other fields in based on the contents of the columns of the selected part in the combo box. me.description = Me.cboPartNo.Column(2) me.cost = Me.cboPartNo.Column(3) .... hth John "uuhhgg" wrote in message ... I would like to have a form with a combo box where I can select a part number and after I select that part number to have the rest of the form fill in. |
#4
|
|||
|
|||
combo with auto fill Access 2000
I'm not that good with code. where would I put it? It looks like it will do
what I want it to but I'm just stupid when it comes to code. I'm more of the point and click type "Jeff Boyce" wrote: Create a form with the fields you want to display. Create a query that returns all records for the form. On the form, add an unbound combobox that lists part numbers. The Header is a good location. Modify the query to look at the form's combobox as a selection criterion for the part number field. This will look something like: Forms!YourFormName!cboYourComboboxName In the combobox's AfterUpdate event, add something like: Me.Requery (this will cause the form to recheck its source, the query, which uses the combobox selection to return a single record) It that what you are trying to do? Regards Jeff Boyce Microsoft Office/Access MVP "uuhhgg" wrote in message ... I would like to have a form with a combo box where I can select a part number and after I select that part number to have the rest of the form fill in. |
#5
|
|||
|
|||
combo with auto fill Access 2000
The newsgroups here provide great support for answering specific questions.
Yours seems more like a general tutoring session or a class in designing forms and using Events. Since most of us here are volunteering our time, you may not find many who can afford to volunteer to do this training. You might want to see if you can locate a local or on-line class covering these topics. If you have little-to-no experience working with Event procedures, this might be the opportunity to gain some. Regards Jeff Boyce Microsoft Office/Access MVP "uuhhgg" wrote in message ... I'm not that good with code. where would I put it? It looks like it will do what I want it to but I'm just stupid when it comes to code. I'm more of the point and click type "Jeff Boyce" wrote: Create a form with the fields you want to display. Create a query that returns all records for the form. On the form, add an unbound combobox that lists part numbers. The Header is a good location. Modify the query to look at the form's combobox as a selection criterion for the part number field. This will look something like: Forms!YourFormName!cboYourComboboxName In the combobox's AfterUpdate event, add something like: Me.Requery (this will cause the form to recheck its source, the query, which uses the combobox selection to return a single record) It that what you are trying to do? Regards Jeff Boyce Microsoft Office/Access MVP "uuhhgg" wrote in message ... I would like to have a form with a combo box where I can select a part number and after I select that part number to have the rest of the form fill in. |
Thread Tools | |
Display Modes | |
|
|