Question (1 Viewer)
- Thread starter Nicolette
- Start date
What do you want to populate?
You select the CustomerID and then you will have two sets of data showing on your Main Form.
One set is the fields displayed from your tblOrderHeader which will be OrderID (autonumber) OrderDate - you enter this. You can set the form control to use =Today() as default,
The Other is data from the tblCustomer which won't be in the tblOrderHeader.
You can use another SubForm - just a small one - to display this data and link it with CustomerID to CustomerID. This will be "Read Only" and you should make the text box controls properties to not allow any edits etc.
You select the CustomerID and then you will have two sets of data showing on your Main Form.
One set is the fields displayed from your tblOrderHeader which will be OrderID (autonumber) OrderDate - you enter this. You can set the form control to use =Today() as default,
The Other is data from the tblCustomer which won't be in the tblOrderHeader.
You can use another SubForm - just a small one - to display this data and link it with CustomerID to CustomerID. This will be "Read Only" and you should make the text box controls properties to not allow any edits etc.
You can use many Sub Forms but normally you can do this task with a Main Form and One large subform to take the OrderDetails and maybe a smaller subform to show the Customer Name and Postal Address data on the main form.
You can get away without this smaller subform by using unbound text box controls and expressions to get the info from tblCustomer but this may be stage two.
Don't disspear as Access is like this. Quite a lot of work to set up but once done, very little to do later.
You can get away without this smaller subform by using unbound text box controls and expressions to get the info from tblCustomer but this may be stage two.
Don't disspear as Access is like this. Quite a lot of work to set up but once done, very little to do later.
That is the way it is done but of course, where is it coming from?? which is why a subform can do this.
get this form looking how you want and then you can add the Command Buttons to make it :
Add New Orders
View existing Orders
Allow Deletion - if you wish
Edit existing Orders
All four, or more options can all be done with the one form.
ok thanks for the words of encouragement i was getting a bit frustrated. I wasn't sure if i was clearly explaining what i wanted, which i had seen done in sample databases I expected a ton of work which i am hopeful will be well worth it when i get it done
Check the table and see what is in that, if .99 then it should just be the Form's text Box Control format property.
This should be set to Currency and two decimal places.
Sometimes you can use an expression to get the rounding exact as the opposite can be a problem where the Invoice Total on the form/Report is 1cent out because you see .99 but it really is .99567834
This should be set to Currency and two decimal places.
Sometimes you can use an expression to get the rounding exact as the opposite can be a problem where the Invoice Total on the form/Report is 1cent out because you see .99 but it really is .99567834
See attached Database (access 2000).
QryOrderTotal
This query also calculates the OrderDetail sales total including Sales Tax and Round's the result to two decimal places.
QryCustomerSalesTotal gives you sales summed by Customer and it includes Nz([fieldname],0) to avoid Null values which will make a mess of your calculations.
FrmSales shows how a form can display data from the record source and have an unbound text box control to do a calculation.
QryOrderTotal
This query also calculates the OrderDetail sales total including Sales Tax and Round's the result to two decimal places.
QryCustomerSalesTotal gives you sales summed by Customer and it includes Nz([fieldname],0) to avoid Null values which will make a mess of your calculations.
FrmSales shows how a form can display data from the record source and have an unbound text box control to do a calculation.
