Hello :D

I have a small problem. I have three Access forms one is the main form(frmAgreements) which has two command buttons. Each command button opens a form which is linked by the field AgreementNo. One of the forms (frmTasks) works great when the button is clicked it only displays the records pertaining to the Agreement No selected. The second form (frmInvoices) however does something quite funky. The second form has a subform. When I am in the main form (frmAgreements)and I click the button to go to the second form(frmInvoices) it does filter the records correctly on both the frmInvoices and subform, but I want one the main field of the subform which is the InvoiceNo to display automatically. I went to design/view of the subform then I went to default view and put [Forms]![frmInvoices]![InvoiceNo] and then when I go back to the Invoice Form it tells me it cannot perform action at this time. Then it freezes the whole db. Any suggestions? Thanks you

slypunk

__________________
slypunk

Can someone please help me on this I am still stuck.

Thanks

slypunk

How about Forms.frmInvoices.form.InvoiceNo ?



Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Yeah I tried that and it gave me a #Name? error. I also did Forms.frmInvoices.InvoiceNo and that gave me the same error too.:(

slypunk

This is the message I receive when I use Forms!frmInvoices!InvoiceNo as the default value in the design view of the subform.
It tells me "You can't carry out this action at the present time."
I just have to fix this problem before placing on the server for users to start utilizing it. Any help I would greatly appreciate.

slypunk