Recent content by access8

I received your email and thank you for responding. I sent you several attachments so you can view the errors that I am receiving.

ok thanks scriverb will do. :D

I got the synchronization to work by reading this article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;236368 I am still playing around with the code but I sure did not think it would be this difficult. If you have any other suggestions. Please let me know. Thank you very much. :D

I was at first putting the code u gave me which sort of worked it seems now that anything I do even if I use the original code which was Forms!InvoiceNo!frmInvoices in the default value of the InvoiceNo field in the subform it stil give me the #Name? error. I am not sure why. Any other...

Nope what I did, did not make too much of a difference it is giving me a #Name? error. It's almost working in fact when I enter a new comment in the subform the #Name? error displays automatically. So in other words in this code it is not recognizing something.

Ok now I am getting the #Name? message....let me try something with this and post back...:D

I'm sorry but I do not undertstand. I write the code in the default value of the InvoiceNo field but it gives me an error saying that it cannot find the macro. Does this go in the On Current event???

Cool. Thank you very much for your help the information you have provided has been helping me little by little. Hopefully by the end of this month I can get this puppy(database) to run as it should. Thank you again :D

when I create a new record in the frmInvoices the InvoiceNo field in the subfrmComments appears automatically. In the old db, I used [Forms]![frmInvoices]![InvoiceNo] in the default value of the InvoiceNo field but here with the new db it does not allow me it gives me an error of "cannot...

I'm sorry I forgot to add that when I do that and I open the frmInvoices that is when it gives me the error "Invalid use of null".

Quote: When you frmAgreements opens is there an InvoiceNo in the control? Or is the error occuring prior to opening? Is the error occuring and then a line of code being displayed? Which one. Not in the frmAgreements, the InvoiceNo field is in the frmInvoices which is linked to the subform...

It is giving me an error of "Invalid Use of Null". Hmm weird....

I am not sure if I am doing something wrong but when I open the frmInvoices where the subform is placed a 0 is shown on all records. :S

I tried going to the build button but it is grayed out. I think I am better demonstrating this than explaining it. Here is how this works: All forms are linked by the AgreementNo field MAIN FORM: frmAgreements Button One: frmTasks (linked by AgreementNo field) Button Two: frmInvoices(linked by...

Quote: Now the new record row has a blank InvoiceNo which we can prefill for you if that is what you want. Yes this is exactly what I need I am very sure it will be bothersome for the user to input the Invoice No instead of it displaying automatically. Reason why I ask is because I am...