another dlookup question

[spnz]

Hi there

I am playing around with with the dlookup function with populating from a combobox.

This is what I am trying but its not working

=DLookUp("[PhoneNumber]","tblLineManager","[LineManagerID]=cboBookingContact(0)")

Basically what I am trying to do is use a combobox to populate a textbox. The combobox has 2 columns (the 1st is hidden which is the tables primary key) I am trying to get the dlookup to look at the primarykey ID on the combobox and autopopulate the textbox with the phone number.....


Can anyone see what I am doing wrong?

 

[spnz]

Thanks again Pat

Its great seeing some of the features in action!!