I tried this in my form that is for editing existing records only. I got
error 2046, Command RecordsGoToNew is not available at this time. What did I
do wrong?
Nothing, the form doesn't allow to add records, access tells you that
you are not allowed to do this, if you add a new record.
Set the starting recordsource to a query that shows no-records, like
a: SELECT * From table WHERE 1=2
and after you choose something from the comboBox:
me.recordsource=SELECT * From table WHERE thisfield=me.combobox
If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW