To disable the field until the supplier field is not null I guest in this case i will prefere that. But which code do i need to use and where should i place the code?
Its working but there are some issues that I encounter:
1. After entering a record, there are saved in the tables but the form is not cleared for the next transaction to take place.
2. For this second issue plse so the following on the form to understand better:
a) Select a product name...
Thank you Dewl
I think i will only have to use autonumber as primary key in the table TblStock.
My second worry lies on the VBA you supplied. By your proposal, where should i attached this code? If possible, you could attached it to a form in the DB and upload.
Waiting to hear from you
Using the dcount function and deleting records in the TblStock to me I think will call an error msg to be populated. This is based on how the PurchaseID is being form.
Remember the PurchaseID is automatic and it counts the number of records, then adds one(1) to create the next PurchaseID...
I wish to create a forms that has command button which display a drop down list. The drop down list should contain commands for reports and forms.
Lets assume we have forms named “FrmStock”, “FrmSales” and we also have Reports named “RptUserLog” , “RptTurnover”.
How can I go about that. If...
I have a table in my DB named TblStock and another named TblStock2
I also have a form in the DB named "frmStock" with the control source being "TblStock" . This form has a sub form "FrmStock2Subform" with control source being "tblStock2". The two forms are lined by "PurchaseID". This form is...
Greetings to u all out there.
Am an accountant and i got to realise the grandeur in Access when i wanted to run a small school. I needed a DB to store data for all students and teachers. Then I got to know about Access. That was in February 2013, by March 2013 I was able to develop my first DB...