populating data into a combobox using dlookup

Jeff · Jun 22, 2005

Hi,
When I try to copy data into an unbound combobox using dlookup, i got the
following error:
run-time error '2115'
The macro or function set to the BeforeUpdate or ValidationRule property
for this field is preventing Microsoft Access from saving the data in the
field.

I have not validation rule set up on the combobox. However, I have the
row source set to a query which brings down the vendor names.

Thanks,

Graham R Seach · Jun 23, 2005

Jeff,

You can't change the value of a control while in the BeforeUpdate event.

I have a feeling you're trying to add data to the combo's list, based on
what the user enters. If this is what you're trying to do, see the following
page:
http://www.pacificdb.com.au/MVP/Code/NIL.htm

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

Jeff · Jun 23, 2005

Graham,
Thanks for your response. I got that to work now, i need to use
controlname.VALUE instead of .text

Jeff