Access 2003 form and report assistance needed

sgundrum · 05-29-2008, 07:14 AM

I've got a database that tracks uniform items that is purchased by individuals. The main form has the following on it input boxes on it: Date, Name (Drop down box), Uniform item (Drop down box), Quantity and price. What I want to do is set the price field to automatically fill in with the price of the uniform item when it is selected. I.e. If I select sunglasses, I want the price box to show $6.85. The prices uniform items are in the same table as the uniform items.

The second thing I need to do is create a report to print each individual on their own page. I.e. all of steve's stuff will be on a page, all of amber's stuff will be on its own page.

Any and all help is appreciated.

Thanks

sgundrum · 06-01-2008, 02:35 PM

I've got the report issue fixed. All I need know is someone to help me figure out how to make a text box automatically fill with the price of an item selected in a drop down box.

David M58 · 06-01-2008, 05:16 PM

Let's say you have a form with a combo box named Price_Combo and a text box named Display_Price. You could use an On Change event procedure in the combo box to fill the text box with the selected price. The combo box code might look like this:

Code:

Private Sub Price_Combo_Change()
    [Display_Price].Value = [Price_Combo].Text
End Sub

05-29-2008, 07:14 AM	#1 (permalink)
sgundrum Registered User Join Date: Jan 2005 Location: Nampa,ID Posts: 76 OS: XP Pro / Redhat Linux	Access 2003 form and report assistance needed I've got a database that tracks uniform items that is purchased by individuals. The main form has the following on it input boxes on it: Date, Name (Drop down box), Uniform item (Drop down box), Quantity and price. What I want to do is set the price field to automatically fill in with the price of the uniform item when it is selected. I.e. If I select sunglasses, I want the price box to show $6.85. The prices uniform items are in the same table as the uniform items. The second thing I need to do is create a report to print each individual on their own page. I.e. all of steve's stuff will be on a page, all of amber's stuff will be on its own page. Any and all help is appreciated. Thanks __________________ True professionals establish excellence as their goal and never allow themselves to become complacent about their performance..

06-01-2008, 02:35 PM	#2 (permalink)
sgundrum Registered User Join Date: Jan 2005 Location: Nampa,ID Posts: 76 OS: XP Pro / Redhat Linux	Re: Access 2003 form and report assistance needed I've got the report issue fixed. All I need know is someone to help me figure out how to make a text box automatically fill with the price of an item selected in a drop down box. __________________ True professionals establish excellence as their goal and never allow themselves to become complacent about their performance..

06-01-2008, 05:16 PM	#3 (permalink)
David M58 Registered User Join Date: May 2008 Location: Baltimore, Maryland Posts: 160 OS: Windows XP SP3	Re: Access 2003 form and report assistance needed Let's say you have a form with a combo box named Price_Combo and a text box named Display_Price. You could use an On Change event procedure in the combo box to fill the text box with the selected price. The combo box code might look like this: Code: Private Sub Price_Combo_Change() [Display_Price].Value = [Price_Combo].Text End Sub Last edited by David M58; 06-01-2008 at 05:18 PM.