A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Coding in form for a2003



 
 
Thread Tools Display Modes
  #1  
Old March 1st, 2007, 05:01 PM posted to microsoft.public.access.forms
dbspl1
external usenet poster
 
Posts: 4
Default Coding in form for a2003

I have an Orders form. It contains fields tied to an Orders table for Invoice
Number, Order Date, Line Total, and Supplier ID, and a subform Order Details
that is connected to an Order Details table that lists in a datasheet Product
ID, Quantity Ordered, Quantity Shipped, Unit Price, Subtotal, and Sales Tax.
I also have a Product table that lists Product ID, Product Name, Unit of
Sale, Unit Price, Taxable (yes/no), Hazardous (yes/no), Supplier ID. I've
created my one-to-many relationships and the Orders form is functioning
properly. But I would like to take it a step further. In the Orders form I
would like to be able to choose the products that were ordered (whether one
or several) for each invoice, have its associated data pull up in the form,
and be able to change field data to allow for price fluctuations. Also,
currently the Subtotal and Sales Tax fields in the Order Details table are
manually entered; is there a way to automatically calculate these? To sum up
I am looking to improve my Orders form to give the user the ability to,
having entered the invoice number, order date, line total, and supplier id,
choose from a combo box the products ordered, have that choice reflect in the
form, update the price as necessary, and move to the next product for that
order. Thanks for any help.

Brian
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:16 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.