Forms Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a form based off of a query that derives information from one table
and one query. In the form I've made name a combobox so that when I click on
someones name their company automatically shows up and I can input if they've
been formally trained or not (to track training).

However, when I open the form and click on the combo box the names appear
but I can not select one. It just sticks. Any ideas?
 
Dear Friend,

The problem will be due to the relationship factor. The query may have
already contain a primary key. In the form again you embedded the same table
and results from query. This can cause the problem. I had the same problem
before.

I suggest you to insert a combo box in the main form and in the subform you
fetch all the details that you wish to view.

The combo box will fetch the [Employee Name] and you ensure that the Master
and Child Lins is set between the Main and Sub forms using [Employee Name].

When you select an employee name the subform will change the details
instantly and quickly. The earlier method may be a little slow.

Hope that helps you.
 
Sir,

That didn't solve the problem, but was very useful information. My combobox
remains static, I still cannot select a name in the main form. Any other
suggestions?

Maha Arupputhan Pappan said:
Dear Friend,

The problem will be due to the relationship factor. The query may have
already contain a primary key. In the form again you embedded the same table
and results from query. This can cause the problem. I had the same problem
before.

I suggest you to insert a combo box in the main form and in the subform you
fetch all the details that you wish to view.

The combo box will fetch the [Employee Name] and you ensure that the Master
and Child Lins is set between the Main and Sub forms using [Employee Name].

When you select an employee name the subform will change the details
instantly and quickly. The earlier method may be a little slow.

Hope that helps you.
--
Maha Aruppthan Pappan
Nacap Asia Pacific (Thailand) Co., Ltd.


franklinbukoski said:
I created a form based off of a query that derives information from one table
and one query. In the form I've made name a combobox so that when I click on
someones name their company automatically shows up and I can input if they've
been formally trained or not (to track training).

However, when I open the form and click on the combo box the names appear
but I can not select one. It just sticks. Any ideas?
Click to expand...
Click to expand...
 
Back
Top