combobox and copy records in forms

[ronaldff]

Hi

I have two questions about forms:

1 Can I copy a record in form view and than paste it back still in fom view;(to be edited after paste)?


2 I would like to use a two-column combobox on a form; I have set all the values into row source, set row source type to value list, and set the control source. it all works fine! my question is that the list of data items for the combobox are of the form "a";"some text in col2"; I have also entered text in rowsource without the quotation marks via the zoom facility - and that works too. So, please, what is the correct format for the list items - with or without quotation marks?

many thanks Ron

 

[wazz]

you can use this to copy a record to a new record:

    DoCmd.RunCommand acCmdSelectRecord
    DoCmd.RunCommand acCmdCopy
    DoCmd.GoToRecord , , acNewRec
    DoCmd.RunCommand acCmdPasteAppend

for a value list, not sure. i've noticed that too. i use quotes. i think quotes might be required in code. (?)

 

[ronaldff]

Thanks for that info; not sure that I have reached that level of coding expertise - being a newcomer to Access 2007!

Ron