alain versa
Last Activity: Dec 5 '11, 08:17 AM
Joined: Nov 22 '11
Location:
-
Do you mean as a form + datasheet subform rather than as a form with two linked datasheet subforms? I would prefer not to as it is much easier to navigate in a datasheet given the way users interact with it in this particular business model. -
Reason was that I wanted to show both headers and lines as datasheets, so users can easily browse transactions, select one and then view the associated lines. Processing is not linear, user sort and filter by different criteria depending on the available source documents (screenshot attached)
[imgnothumb]http://bytes.com/attachments/attachment/5692d1322010284/invoice-menu.jpg[/imgnothumb]...Leave a comment:
-
Some more information:
If I sort the transaction line records differently in the form, I can edit the line on top.
What it looks like doing is that it refocuses the cursor on the first line after every click in the transaction lines subform - that also explains why I can edit the Boolean (since that is one click). Is there a way around this?Leave a comment:
-
Access 2003, and I did create the forms myself.
The only code associated with this form is a Docmd.Openquery which runs an append query which adds a new transaction line for the transaction header selected if required by a user.
These new lines then share the same Transaction identifier so they show up correctly in the transaction lines form (but as mentioned, can't navigate or edit them)Leave a comment:
-
cannot navigate / edit subform beyond first record
I have one unbound form which contains two subforms.
The record source of the first subform is a table containing transaction headers.
The record source of the second subform is a table containing transaction lines.
The link between the two tables is the Transaction identifier: relationship is one (in headers) to many (in lines)
The selection works perfectly - it shows all lines associated with a particular header in the...
No activity results to display
Leave a comment: