Suggest VBA

Hello guys, i'm new here..

I'm doing a computing project... and i'm supposed to have some coding there... and i kind of don't have any ideas..

Well, the program is about customers purchasing furniture(OrderID), invoices, debts, etc etc...

Can someone suggest anything what i can do..

At the moment i have some basic things like :

1. If txtQuantity <0 then
msgbox"Quantity field can't have 0 value"
Else
End If

2. If chkPrintReport1.Value = -1 Then
DoCmd.OpenReport stDocName, acPrintAll
Else
End If

Most of my project is done using SQL statements like AmountDue, Discount etc.. and macros, i just need some coding...

Any suggestions would be appreciated.. Thanks in advance.

anyone?