Cannot select a combobox from a subform

[Aximboy]

I have 2 tables, tblEmployees and tblManagers

I have a main form which contains Employees name & info and a subform with Managers name & info.
From time to time employees get switched around from different managers. So from the subform I have a combobox that I can select the managers name and upon selection, it displays that particular manager's info on the textboxes on that subform.

The problem is when selecting managers from the subform's combobox I get an error "You can't use Find or Replace now." I don't get this. What am I doing wrong? Is there a better way to get this working?

Thank you in advance.

 

[missinglinq]

What am I doing wrong? Is there a better way to get this working?

No way to tell! You've told us what you're trying to accomplish, but haven't said a word about how you're trying to do it! How are you trying to retrieve the Manager's data?

Also, it would appear that you've got your cart before the horse! A Main Form/Subform scenario is normally used to display a One-to-Many relationship, and in most business entities the 'One' would be the Managers and the 'Many' would be the Employees.

A Manager and his info would appear on the Main Form, and the Subform would show all Employees, with their data, who report to that particular Manager. Is this not the situation at your company?

The Missinglinq

Richmond, Virginia

The Devil's in the Details!