Combo Box Works in a Form But Don't update the Form Field using the Combobox Value

[carlosd]

This DLookUP works correctly...

UNDER CONTROL SOURCE:
=DLookUp("[First Name]","Contacts","[Combo378]='" & [Forms]![PROFILE]![Combo378] & "'")

but when a I want to close the form, display the error:

You must enter a value in the Profile.First Name

I junt need the way to update the field in the new table...

 

[BlueIshDan]

Take a deep breath and try to explain this to me again.

What does your form do.
How are you trying to update a record in a table using this Combo Box's value.
What is the condition on the combo box and form before you try to exit.

 

[carlosd]

OK...

I have a original Form with Customers Name, Initial, Last Name, Mobile Phone Number, Home Phone Number, Email, etc...
This Form use the Table = Contacts

I have the 2nd Form with new fields related to the same Customer, but I want to load the Customer Information located in the CONTACTS Table... because I dont want to type again the Customer Information, just fill the new fields in this 2nd Form.
This 2nd Form use the Table = Profile

 

[BlueIshDan]

If I'm understanding right you should have a unique identifier for each profile/contact. Also make sure you normalize your table designs it could save you a boat load of time and struggle. I'm getting the feeling that your tables are not normalized.

For the initial problem:
If you had a unique identifier on your records you could quite simply load that one profile/contacts information on a form.

As for your error, you did not provide me with any information that could help me solve this problem.

 

[vbaInet]

... because I dont want to type again the Customer Information, just fill the new fields in this 2nd Form.

Put this in the Default Value property of the textbox:

DLookUp("[First Name]","Contacts","[Combo378]='" & [Forms]![PROFILE]![Combo378] & "'")

By the way, is that red part correct? Is there a field in Contacts called Combo378? I doubt it.

 

[carlosd]

Tks for your Answer...

Yes... is Combo378

I remove the Dlookup from the TXTBOX Control Source... and I put that in the Dafault Value... but the Form continue asking for the Firts Name Field... = MSG (You must enter a value in the Profile.First Name)

 

[vbaInet]

Not a very good name for a field.

It will only work for new records. You have to reset your form then go to a new record again.