Subform to Form problems

[jdwazere]

Right heres my database
Have a look what you can do

 

[DevastatioN]

I believe some of the problems was that you never really implemented the code as it was pasted here. Also, you made a "check" value in the query which created a circular loop which completely broke the subform and queries.

I have fixed the database code you requested an reuploaded.

I renamed one of your textboxes to SupplierID instead of Supplier ID. It's usually bad practice to have spaces in the names, also good practice to start table names with tbl... Queries with qry... Forms with frm... and Reports with rpt.

Hope this was helpful!

 

[jdwazere]

Aha ye that sorted most problems just now when ever you click upon 'quantity' and then click the ordercompleted check box, it says 'cannot disable a control while it has focus' again
Also I have a problem in the add order details form as I cannot get it to display the current date in the order date text box, and then save the date in the field 'order date' for each record...it says #name?

 

[jdwazere]

Yeah it doesnt work, I tried testing it and it still comes up with cannot disable a control while it has focus

 

[DevastatioN]

Ok, I fixed it up for you.

There seems to be a problem in Access when you try to remove the focus from a subform to the mainform, there is also a focus maintained on the subform. What I did was make an unbound textbox on the subform named "txtFocus" and set it's width to ".1" so you can't really see it. This will take the focus on the subform when things get disabled.

The second thing I fixed for you was the Date() function, I've seen this done before, at some point in time you named a control or field "Date". Once you do this, the Date() function is erased, meaning you can't use it again (unless you can find out where in Access you can fix it).

Anyhow, here is the updated database with my fixes, hopefully this helps and finally works for you!

 

[jdwazere]

Ok, I fixed it up for you.

There seems to be a problem in Access when you try to remove the focus from a subform to the mainform, there is also a focus maintained on the subform. What I did was make an unbound textbox on the subform named "txtFocus" and set it's width to ".1" so you can't really see it. This will take the focus on the subform when things get disabled.

The second thing I fixed for you was the Date() function, I've seen this done before, at some point in time you named a control or field "Date". Once you do this, the Date() function is erased, meaning you can't use it again (unless you can find out where in Access you can fix it).

Anyhow, here is the updated database with my fixes, hopefully this helps and finally works for you!

Thanks alot for your help, but whilsed at college I managed to work out that I could enable the control 'sub total', which even when enabled, cannot be edited, so i used this as a way of moving the focus and it works fine


Ive also sorted the date control after looking at it, for some reason it worked fine on my college account, just the version at home

My program is complete thanks again