copy data from one record to another

K

Karen Skipper

I've been working on this code and now get an error saying " invalid use of
null". How do I handle null fields (they are okay in what I'm doing)?
Sample of code below:

'save data in fields
emailvar = Me!
extvar = Me![EXTENTION]
phonevar = Me![PHONE]
faxvar = Me![FAX]
origvar = Me![originator]

'code in here to append a new record to the table

'copy data in fields
Me![EMAIL] = emailvar
Me![EXTENTION] = extvar
Me![PHONE] = phonevar
Me![FAX] = faxvar
Me![originator] = origvar


Any help?

Karen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy data to new record 2
Copy and paste slide from one presentation to another presentation gives an error 2
Copy/paste in based on duplicate value in previous row 0
VBA works in orignal but fails in copy of database 1
How to populate fields in one table from data in another table 1
Auto fill fields 3
Copy data from SharePoint list to InfoPath Form 0
View Specific Records within a form 1

Top