thanks, John ~
Dennis, since the message is already on my clipboard, here it is:
~~~~~~~~~~~~~~~~
Dennis,
as Duane is driving to, I believe ... there is an issue creating a record because neither the Produkter table or the Prisdata table should be in the recordset. What you want to fill is records in Orderspecifikationer. They will be linked to your main form via LinkMasterFields and LinkChildFields which will both be set to Produktnr
If you want to echo fields from another table, create a combobox on the subform and use the RowSource to get the other values you want to display. Then you can make textboxes on your form with ControlSource:
=combo_controlname.column(1)
where
1 is the column number -1 ... so column index 1 is actual column number 2
Warm Regards,
Crystal
video -- Access Contact Template, Contact Management System (CMS) Music by Ken Gaines (cc)
~~~~~~~~~~~~~~~
Warm Regards,
Crystal
*
(: have an awesome day :)
*
On Saturday, October 18, 2014 1:14 PM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Dennis-
You can always find older messages at:
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Oct 18, 2014, at 8:14 PM, Dennis Davidsson dennisdavidsson@ymail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Hi Crystal.
you sent me a very detailed suggestion on my problem with my subform the other day, but I had no opportunity to try it out then,
and when I was to look at it today, I found that I accidentally had deleted it from my mailbox.
So my hope now, is that you still may have your answer to me still available to resend it to me.
If this is possible, it would be a great help for me.
Kindly regards
Dennis
__._,_.___
Posted by: Crystal <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (31) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar