Forum Discussion
macro or vba
I would like to show the dates of a subform. When line 5 is completed, I need those dates, if not, the dates of line 4 should be taken, if not, the dates of line 3 and so on till line 0. Can someone tell me how to do?
Thanks
7 Replies
Hi,
> When line 5 is completed, I need those dates
1. What is your "line" in database or Access terms? A record stored in a table or some unbound text boxes in the form or ...?
and related:
2. How is 5, 4, 3..., i.e. the sort order, defined?
Servus
Karl
****************
Access Forever
Access News
Access DevCon
Access-Entwickler-Konferenz AEK - 19./20.10. NürnbergHello,
I wanted to post a document explaining my problem but I see now I posted it to myself. I try again.
Hi,
Just so that anyone responds and your post moves up again: I've looked at your docs, but I still don't understand how your data and your forms, which are really relevant here, are connected. Maybe someone else reading here understands or can clarify.
Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEK - 19./20.10. Nürnberg
Good morning,
I'm sorry I haven't replied earlier but I took a week of.
The line is the sum of a date and a number of days in another form, transfered to a subform in another form, transfered to another subform in yet another form. The last line of this last subform should be put in the form.
I must confess, a collegue who is retired now, made this database. I don't know a lot of access.
Hopefully, my explanation was clear enough for you.
thanks a lot,
Anne
To clarify the problem, I put some printscreens in an appendix
