Help with a smarter form

[m.hatter]

That sounds like an idea, but wouldn't that just leave me with a combo box that only (always) offers only one choice? ir you have a combo box that drops down and presents the one and only choice....ie you really don't have a choice? Being that there is only one BusinessID/BusinessName associated with each contact, I want to just have that value appear without any further selection. I chose a text box.

Actually, this is only a sample data base with no real data and only the tables and forms mentioned. Would you mind just taking a look at the file? frmMeetingEntry is the form we have been discussing. You have basically seen the whole file already. Maybe a real look will reveal something obvious.
thanks.
m.hatter

[maximus]

Suppose u want to lookup a value which is there in a table u can use Dlookup in the after update property of your combobox

e.g i have a table for employees{employee_id,e_Name,Designation} and another table Salary{Link_id,Basic,D.A.} employee_id is linked with Link_id.
now suppose in a form where i have a combox which displays the employee_id and if i want that onec i select an id in TextBox1 name will Appear and in TextBox2 Basic will Appear do the following. (TextBox1 and TextBox2 are unbound text boxes that u will create while designing the form). in the combobox AfterUpdate Event type the following code

Me.TextBox1=Dlookup("[e_name]","employees","[employee_id]="&Forms!Name of your Form!Name of the ComboBox)
Me.TextBox2=Dlookup("[Basic]","Salary","[Link_id]="&Forms!Name of your Form!Name of the ComboBox)

follow the example and let me know the result my email silverback_bats@yahoo.co.in

[RuralGuy]

Here's one way to do it.