Filling the field in form

[dk]

In my form I have 3 fields.
Country calling code (cmbCountry)
City calling code (cmbCity)
Phone number (txtPhone)

After the user selected country and city code, those values shall be putted
into field txtPhone, so the first caracter user put into starts after that.
EG: cmbCountry = 1
cmbCity= 32
txtPhone= +132(starting entry point)Phone number

Thank You in advance for any suggestion or code.

Regards,
dk

 

[Mark Hyland]

Hi,

You could write some code on the after update event of the field cmbCity,
that populates txtPhone eg

forms![formname]!txrPhone = "+" & forms![formname]!cmbCounty &
forms![formname]!cmbCity

Replace formname with the name of the form you are using.

Hth

Mark

This information is provided "as is" and confers no rights or expresses no
warranties.