Get value from subform

[LennyNero]

Hi,

I need to display on the main form the total number of records in subform plus a total of a column.
I've tried some solutions i found but didnt work like Dcount on a control.

Thanks for your help,
Luis

 

[khawar]

Here is a sample for you

 

[LennyNero]

hi,

That's great, just what i needed.

Thanks khawar

I need now on another form, that displays the last record number on a table, then by pressing a button it goes to the form on the same record number.

Thanks again for your help.

 

[khawar]

Cant understand

 

[LennyNero]

hi again Khawar,

Sorry i didnt explain well, when the user opens the form, it displays something like:
Your last invoice was number: 10 want to create number 11?
Then on clicking yes it will create the number 11 record and open the form on the number 11 also.

Thank you.

 

[khawar]

Download the attached sample and open the form invoiceMain

There are already three invoices saved in tablemain so on opening it will ask you whether to creat invoice number 4 or not

If you select yes it will add a new record with invoice number 4 else it will show you last invoice created i-e invoice number 3

 

[LennyNero]

hi Khawar,

Thanks for your help, because of you this is working pretty nice

I just need one more thing, when the user selects to create a new invoice, the new invoice number must be created on all records in a table that doesnt have that field.

To explain when the invoice is created, the details for it are already there on a table i create from a make table query based on dates, i then have to associate it with the new invoice.

Dont know if its the best way but its the way i thought of it.
Hope you can help but if you dont you already did a lot and i thank you again.

Regards,
Luis

 

[khawar]

Dont understand what do you want give some detail along with some sample data

 

[LennyNero]

hi again Khawar,

I attached my database, table documentos (like invoices) and documentoslinhas (details of invoices) are attached tables from access2.0 database.
The purpose of it all is to gather all invoices from the details that are from a specific customer, then export all to a txt file with header and footer and the details on the midlle (i already made the code for the header in a module)
What i did is query the documentoslinhas to create a new table, then create a update query to fill the data i need. What is missing is the relation from the details to the header (invoice number)
Also how to get it all in one text file.

Thanks,
Luis