SQL-kopiering af record

The code you use to copy a record should work, also with a combo.

What problem do you get?

INSERT INTO tidsforbrug(felt1, felt2)
SELECT forms!DinFormular!felt1 AS Expr1, forms!DinFormular!felt2 AS Expr2;

Så skal du bare huske, at det er det felt i komboboksen, som er sat under egenskaben "bundet kolonne", som der refereres til (det er måske også det problem, du sidder med nu!~)

Hovsa.... Go'morn.. Terry..

Ja, som Terry siger, så burde det virke!~)

Morning every one :o)

If the relationships are in place between the bound field in the combo and the table where the records in the combo are taken from, then ther should be no problme at all using the code you use.

Hej Terry,
I is not easy to explain, but I can send you a little Acces example, which illustrate my problem. You can then try it yourself and maybe see what I am doing wrong.
I am agree - my code should work - but it does not. 

Do you have a mail I can use ?

Vh. OMN

ekspertenATsanthell.dk
AT = @

I think the problem is because the text in the visible column is not unique so it takes the first value which matches. If they were unique it would work ok I think. Anyway a quick and dirty solution :o)

Make the first column which is unique visible before you copy and then hide after.

Me.[AID-Fakt].ColumnWidths = "1cm;4cm;2cm;2cm;5cm;4cm"

    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
    DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append
    DoCmd.GoToRecord , , acLast
   
Me.[AID-Fakt].ColumnWidths = "0cm;4cm;2cm;2cm;5cm;4cm"

does this help Ove?

Yes Terry - It works very well, but I have redesignet my code so that I not use a hidden column.

Thanks. OMN