Another question on Combo Boxes

[jas2unow90]

I have a form to enter Daily logs for the employees out on the road. When
they enter in a new job number there is a combo box for the customer name and
one for the location based off of the customer. My problem is that when
there is a new customer, I need to be able to have them enter a new location
and be available in the combo box. Can someone help me???

 

[Jeff Boyce]

Have you looked into using the NotInList property & event?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[jas2unow90]

Thats how I have it now. If the user has to enter in a new customer, then
the location also would be new. But when the location combo box is updated
it comes up with an error because there are no records.

 

[Jeff Boyce]

Without more of an idea of how your underlying data is organized, it will be
tough guessing what might be happening...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/